Countdown....

[Rusty]

I want to create a countdown timer, so that in cell ‘A1’ I have today (using Now formula) In cell ‘A2’ I have a set date (say, Christmas)

Then be able to show how many days, hours, minutes and seconds left to go, all in separate cells.

Any help would be appreciated....

[Ivan F Moala]

On 2002-04-15 02:55, Rusty wrote:
I want to create a countdown timer, so that in cell ‘A1’ I have today (using Now formula) In cell ‘A2’ I have a set date (say, Christmas)

Then be able to show how many days, hours, minutes and seconds left to go, all in separate cells.

Any help would be appreciated....

You could use appliation Ontime method.
But I have found that using the IETimer is
easer and doesn't give you too much flicker.

Post if you want me to send example....easier
then explaining it.

[Rusty]

If you could, it would be much appreciated

russell_hackett@storagetek.com

[Ian Mac]

On 2002-04-15 02:55, Rusty wrote:
I want to create a countdown timer, so that in cell ‘A1’ I have today (using Now formula) In cell ‘A2’ I have a set date (say, Christmas)

Then be able to show how many days, hours, minutes and seconds left to go, all in separate cells.

Any help would be appreciated....

If your NOW() is in A1 and the target date/time is in B1.

Use:

C1 =INT(B1-A1)&" Days"
D1 =TEXT(B1-A1,"hh")&" Hours"
E1 =RIGHT(TEXT(B1-A1,"h:mm"),2)&IF(RIGHT(TEXT(B1-A1,"h:mm"),2)+0<>1," Minutes"," Minute")
F1 =RIGHT(TEXT(B1-A1,"h:mm:ss"),2)&IF(RIGHT(TEXT(B1-A1,"h:mm:ss"),2)+0<>1," Seconds"," Second")

it won't countdown automatically, but someone could put some code behind it to do just that.

[alunowie]

you could count the days manually...

[Chris Davison]

On 2002-04-15 04:11, alunowie wrote:
you could count the days manually...

Poster wants "to create a countdown timer" not do it manually