How to insert the current time and date into an Excel 2010 spreadsheet

This is a cute little trick.  Excel 2010 (and probably earlier versions, also) has the ability to use “now()” and “today()” in cells.  With this, you can have time-based calculations without needing the user to supply a current date/time.