http://www.mvps.org/dmcritchie/excel...ime.htm#clocks

look for real time clock

--
Regards,

Peo Sjoblom

Portland, Oregon




"Bob Newman" wrote in message
news:2qeEf.1848$c64.535@dukeread12...
I have the simplest of formulas to give me the time until an event takes
place. In one cell I have the now function ( =now() ). In another cell
the date/time of the event. In a third cell the event date/time-now
formula (formatted h:mm:ss). It works fine but I have to hit F9 to
recalculate. Can I get it to display a constantly updating time showing the
seconds ticking away? Also how can I get it to show the months and days
away an event is in addition to hours/min/sec?

Thanks... Bob