countdown clock

[Frank Kabel]

Hi
see: http://www.mvps.org/dmcritchie/excel/datetime.htm

at the bottom of this page

 

[Frank Kabel]

Hi
a countdown timer: No

 

[mklalli]

="There are "&ABS(ROUNDDOWN("12/24/2004 23:59:59"-NOW(),0))&" days
"&ABS(HOUR(NOW())-HOUR("12/24/2004 23:59:59"))&" hours
"&ABS(MINUTE(NOW())-MINUTE("12/24/2004 23:59:59"))&" minutes, an
"&ABS(SECOND(NOW())-SECOND("12/24/2004 23:59:59"))&" seconds left unti
Christmas!"

results:

There are 135 days, 9 hours, 22 minutes, and 51 seconds left unti
Christmas!

When it is 8/11/2004 14:37:08.

Is that what you mean