If you want to cause a recalculate every second or so - but then excel
basically becomes a clock.
Look at Chip Pearson's page on Application.Ontime
http://www.cpearson.com/excel/ontime.htm
--
Regards,
Tom Ogilvy
wrote in message
...
That looks pretty good, but is there anyway for the
seconds to continue to countdown while one is viewing the
page?
-----Original Message-----
Put the future date/time in cell A1
in Cell B1 put in
=TEXT( A1-NOW(),"[hh]:mm:ss")
This will give you the difference in hours, minutes and
seconds. It will
adjust each time there is a calculation.
=TEXT( A1-NOW(),"[mm]:ss")
This gives minutes and seconds.
--
Regards,
Tom Ogilvy
"Kreiss" <anonymous
wrote in message
...
Is there anyway to have a cell with a running countdown
from one date to another. For example, the number of
seconds left or the number of minutes and seconds from
today's date and just say a year from now.
Thanks in advance,
Kacy
.