Tuesday 18 December 2007

Foresight and the Present in Excel

Here are two totally different things that excited me today.

Number one, the ancient gods Prometheus and Epimetheus. The former is the god of foresight and considered pretty wise. The latter is the one of hindsight and considered slightly foolish. Invoke either or both as needed in your daily work. I am not sure if they take animal offerings.

Number two, if you need to add the current data and/or time in Excel, there are two ways. One is to use the now(), date() or time() functions if you want the date and time to always be your current PC time (i.e. a dynamic date). However, if you want to just enter a static current time, such as a manual time stamp for an entry, you can use Ctrl and “;”. As per the manual:
Current date - Select a cell and press CTRL+;
Current time - Select a cell and press CTRL+SHIFT+;
Current date and time - Select a cell and press CTRL+; then SPACE then CTRL+SHIFT+;

No comments:

Post a Comment