Description:
Returns a value of the Date type containing the time.
Syntax:
Date TimeValue(Date time)
Parameters:
| time | (Date) A time from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.) |
|---|
Note:
If the time parameter contains date information, then function does not return the date information. However, if time contains 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.
For conversion of
String values to
Date it is better to use the
Pm.ScanDate method.
Example:
VBScriptSelect and copy to clipboard
Dim tTime
tTime = TimeValue("4:35:17 PM")
' tTime contains 4:35:17 PM