You can download the countdown spreadsheet if you like. Just click on the
link below. Let me know if this helps.

http://www.mediafire.com/?sharekey=6...75f6 e8ebb871

"Ryan Proudfit" wrote:

Hello,

I wrote a countdown spreadsheet that subtracts the Now() function from a
future date/time. If you press the F9 key, the countdown updates. If you hold
down the F9 key, the countdown continues to update. Various formulas break
down the difference between the two dates/times into the individual
components below, then string them together with text for a readable format.
Here is an example:

403 Days (1 Years 5 Weeks 3 Days) 14 Hours 10 Minutes 10 Seconds
9,686 Hours (24/Day)
581,170 Minutes (1,440/Day)
34,870,210 Seconds (86,400/Day)

I can email the spreadsheet to you if you'd like.

Ryan

"Keith" wrote:

Hello,

According to Excel Help, if I want to set a date, I can use€¦
Date statement is shown as

MyDate = #February 12, 1985#

And if I want to set an hour in the day, I can use the time as

MyTime = #4:35:17 PM#

But how can I specify a day and a time together, so I can then do a
count-down timer and show the minutes remaining or the days, hours, minutes
and seconds remaining?

Thank you,
Keith