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