Count Down in Cell
 

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

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

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


.

Count Down in Cell
 

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


.