Need a countdown timer

  • Thread starter Thread starter Keith
  • Start date Start date
K

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
 
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
 
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
 
Hi Jacob,
thanks very much,
Keith

Jacob Skaria said:
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
Click to expand...
 
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
 
Back
Top