t = TimeValue(time)| time | (Date) A time from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.) |
|---|
If the time argument contains date information, then function doesn't return the date information. However, if time includes invalid date information, then an error occurs.
You can enter valid times using a 12-hour or 24-hour clock. For example, "2:24PM" and "14:24" are both valid time arguments.
Dim tTime
tTime = TimeValue("4:35:17 PM") 'tTime contains 4:35:17 PM