Time without date

  • Thread starter Thread starter Mickey Mouse
  • Start date Start date
M

Mickey Mouse

I'd like the current system time displayed in a cell when I press 'enter'

Only command I know is =NOW() which displays the date and time in a cell.

How do you display only the time? AM PM Doesn't matter.
I've tried looking it up in help but can't but can't seem to find the answer
to my question.

TIA
 
You will not be updating the time when you hit Enter
that is not how Excel works.

If you want to enter a static time you can hit Ctrl+Shift+Enter
so you will have a constant that will not change.

If you want it to update every timer you hit F9 and anytime
a recalculation takes place. Then as Bob suggested
=MOD(NOW(),1) and format as hh:mm:ss
although the time will be calculated when entered it will
change and it will change whenever a recalculation takes place,
which would include changing another cell. (if calculation is on)

The equivalent in VBA is
variable = TIME

For more information on Date and Time see
http://www.mvps.org/dmcritchie/excel/datetime.htm.
 
Back
Top