Count Down in Cell
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
@discussions.microsoft.com 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
|