|
TIMEVALUE(S) |
|
Description
This function 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 other formats are international 24-hour time formats. In all formats, the seconds (SS) can be omitted; in that case, they default to 00. In all formats, the hours can be specified with one or two digits, while the minutes (MM) and seconds (SS) must be two 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.
Refer to DATE for more information on datetime values.
Parameters
S
A string value.
Sponsored
Try Predictive Systems Lab
Need Help?
Contact support