Dynamic Time Display
 

³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

=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.

--
Regards,
Dave


"Jamie Vail" wrote:

³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

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.
--
Regards,
Dave


"David Billigmeier" wrote:

=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.

--
Regards,
Dave


"Jamie Vail" wrote:

³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

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

--
Regards
PY & Associates


"David Billigmeier" wrote in
message ...
=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.

--
Regards,
Dave


"Jamie Vail" wrote:

³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