|
Need a countdown timer
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 |
Need a countdown timer
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 --------------- Jacob Skaria "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 |
Need a countdown timer
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 |
Need a countdown timer
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 |
Need a countdown timer
Hi Jacob,
thanks very much, Keith "Jacob Skaria" wrote: 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 --------------- Jacob Skaria "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 |
Need a countdown timer
Hi Ryan,
Thank you. I'll check it out. keith "Ryan Proudfit" wrote: 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 |
| All times are GMT +1. The time now is 08:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com