Count Down in Cell

[Kreiss]

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

 

[Tom Ogilvy]

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
news:[email protected]...

 

[Guest]

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

@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

.

 

[Tom Ogilvy]

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

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

@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

.