Time in Excel

[ethan2002]

Need to know how to capture the time of day in Excel.....I know how to do the date =today()....but don't understand how to capture the time....sure it is a basic function. Also....I have tried the =now()-today() but the time keeps changing with the PC...how do I keep the time from changing in the cell.


Thanks

 

[fairwinds]

Welcome!

Try:

=NOW()-TODAY()

 

[fairwinds]

Re: Your PM

To get a time that never changes, try the keyboard shortcut:

Ctrl + Shift + :