50. Excel Tips - Tell The Time in Excel
Here are a couple of useful Time-related tips for Excel.
The first one is the NOW Excel function
Lets see how it works..
Enter the following formula in any cell:
For me right now, this returns: 03/02/2009 09:22
NOTE - if the column width is too small, you will see something like this:
All you have to do in this case is to widen the column.
The best way to do this is to select the offending cell, and press in sequence: ALT then O then C then A
- this autofits the column and will now show the time.
Format the cell (right click => format cells => custom) to a good format like:
"ddd dd-mmm-yy hh:mm:ss"
For me right now, this returns:
"Tue 03-Feb-09 09:22:17"
NOTE - NOW is accurate to the nearest second.
The NOW() function in Excel is Volatile, which means that it will recalculate when Excel recalculates .
Be careful on using it with too many dependents, as it can cause sluggish calculation speed.
The second part of this tip is that there is a shortcut to put the time directly into a cell..
Press: CTRL and SHIFT and ;
For me right now, this returns: 09:22:00
NOTE - this is the static time for when you press the shortcut keys
Strangely, the TIME function doesn't actually return the time, however you can use it to tell the time by using NOW as an input.
... clearly a better way to do this is to put =NOW() in another cell, and link to that.
Training Video: Tell time in Excel