Clock display

Topic

New Reply

Hello all,

Is there a formula that will excute an up to the minute running clock that displays the hh:mm in a cell, while the file is open?

Thanks,
Albert

Reply | Quote

Replies

No. You would have to use code with timers and it would bog down your spreadsheet.

Reply | Quote

You could stick a web query to a clock website in your workbook to show the up-to-the-minute time, and set the connection properties to refresh every 1 minute. But, obviously, that’s overkill … but it would work.

One such website:
http://www.worldtimeserver.com/current_time_in_GB.aspx

( right-click over the time and choose Export to Excel … in Excel change Data Connection property to set refresh rate )

Reply | Quote

I may be missing the point, but isn’t there an up-to-the-minute clock at the bottom right-hand side of your screen?

BATcher

Plethora means a lot to me.

Reply | Quote

Yeah, that’s what I look at too. But the request was to have a time embedded in a cell … ( shrug ).

Reply | Quote