Need a countdown timer

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
 
J

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
 
R

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
 
K

Keith

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top