Description:
Returns value of type Date containing the time.
Syntax:
TimeValue(time As Date) As Date
Calling:
t = TimeValue(time)
Parameters:
| time | (Date) Expression representing a time from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.) |
|---|
Note:
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.
Example:
tTime = TimeValue("4:35:17 PM") 'tTime contains 4:35:17 PM