Dynamic Time Display

[Jamie Vail]

³How do I display time in a spreadsheet, I want the format to be Hours,
minutes, seconds am/pm, example 3:15:59 PM

The problem is that I want that cell to be dynamic and updating, anytime
that spreadsheet is open, and is it also possible to have it constantly
updating?

I know how to insert the current time, and update the field, However I want
to display the time field as a dynamic digital clock, referenced to my
computer time.²

Thanks

 

[Guest]

=NOW() and format as Time... Format->Cells->Time

You have to hit F9 for it to update though. There is no way to have it
automatically update without a macro. Even then it would eat up considerable
system resources.

 

[Guest]

Sorry I mean there is no way for it to *Continuously* update without a macro.
This function will update every time you open the spreadsheet, though, and
when you hit the F9 key.

 

[PY & Associates]

Can we put now() in workbook_open event in a continuous loop with a wait
command?