 Formula Engine Reference Guide |
|
Back to Class Index
TIMEVALUE(S)
Returns the corresponding time value for a given string value S. The function interprets the times specified in the following formats:
HH:MM:SS AM or PM (1 <= HH <= 12)
HH:MM:SS (0 <= HH <= 23)
HH.MM.SS (0 <= HH <= 23)
HH,MM,SS (0 <= HH <= 23)
HHhMMmSSs (0 <= HH <= 23)
The first format is the international 12-hour AM/PM time format. All others are international 24-hour time formats. In all formats the seconds (SS) may be omitted, in which case they default to 00. In all formats the hours may be specified with 1 or 2 digits, while the minutes (MM) and seconds (SS) must be 2 digits. The following are equivalent:
TIMEVALUE("12:55:00 AM")
TIMEVALUE("12:55 am")
TIMEVALUE("00:55:00")
TIMEVALUE("00:55")
TIMEVALUE("00, 55, 00")
TIMEVALUE("0.55.00")
TIMEVALUE("0h55m00s")
The result is 0.038194444
Parameters
S
A string value