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
---------------
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

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

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

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

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

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
.

Thanks
rick


"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