View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Count Down in Cell

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



.