Syntax: @TIMEVALUE(S)
S = a string value
@TIMEVALUE 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