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