Need a countdown timer

[Keith]

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

 

[Jacob Skaria]

mydate = #2/12/1985#
mytime = #4:35:17 PM#
myDatetime = mydate + mytime

MsgBox Format(myDatetime, "DD-MM-YYYY hh:mm:ss AM/PM")
MsgBox Format(myDatetime, "DD-MM-YYYY hh:mm:ss")

OR

myDatetime = #2/12/1985 4:35:17 PM#

MsgBox Format(myDatetime, "DD-MM-YYYY hh:mm:ss AM/PM")
MsgBox Format(myDatetime, "DD-MM-YYYY hh:mm:ss")

If this post helps click Yes

 

[Ryan Proudfit]

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

 

[Ryan Proudfit]

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=64af2f044365658d8d78a0e555291609e04e75f6e8ebb871

 

[Keith]

Hi Jacob,
thanks very much,
Keith

mydate = #2/12/1985#
mytime = #4:35:17 PM#
myDatetime = mydate + mytime

MsgBox Format(myDatetime, "DD-MM-YYYY hh:mm:ss AM/PM")
MsgBox Format(myDatetime, "DD-MM-YYYY hh:mm:ss")

OR

myDatetime = #2/12/1985 4:35:17 PM#

MsgBox Format(myDatetime, "DD-MM-YYYY hh:mm:ss AM/PM")
MsgBox Format(myDatetime, "DD-MM-YYYY hh:mm:ss")

If this post helps click Yes

 

[Keith]

Hi Ryan,
Thank you. I'll check it out.
keith

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=64af2f044365658d8d78a0e555291609e04e75f6e8ebb871

 

[RD]

Ryan,

I am looking for a count down timer but when I tried to download your file
it was set to private so I couldn't load it. could you email it to me at
(e-mail address removed).

Thanks
rick