ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Time display (https://www.excelbanter.com/excel-discussion-misc-queries/88593-time-display.html)

grahammal

Time display
 

I have a cell which displays the time but it will only display the
present time when the cell is refreshed. Is there any way I can get it
to update the time automatically?


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=542053


Bob Phillips

Time display
 
Take a look at http://xldynamic.com/source/xld.XtraTime.html, it can be
adapted for what you want.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"grahammal" wrote
in message ...

I have a cell which displays the time but it will only display the
present time when the cell is refreshed. Is there any way I can get it
to update the time automatically?


--
grahammal
------------------------------------------------------------------------
grahammal's Profile:

http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=542053





All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com