Running/Current time in cell?

[SRS]

I know that if I enter CTRL+SHIFT; it will enter the current time of day.

But...is there any formula out there that will insert the time of day and
keep it current? (Basically a running clock, so that whenever the
spreadsheet is open, cell A1 (for example) will always show the current
time???)

Just wondering........

 

[Anne Troy]

Just type =Now() into the cell.
************
Anne Troy
www.OfficeArticles.com

 

[George Gee]

=NOW()

George Gee

 

[George Gee]

SRS

If you wish to display the time only, without the date:
Format ? Cells > Number tab > highlight 'Time'
on the left, and make your choice from the right.

HTH

George Gee

 

[Gord Dibben]

Which will update only when calculation takes place.

Or do you actually want to see the seconds ticking by?

Would take VBA and resources to have that occur.


Gord Dibben Excel MVP

 

[SRS]

Anne & George:
Thank you!

=NOW()

George Gee

 

[SRS]

Thank you for clarifying...I have no clue about VBA (remember, this forum is
titled "New User" ..... so the =NOW() formula will work for now.

Thanks to all for such quick help!