TIMEVALUE
Returns the fraction of a 24-hour day corresponding to the provided time string.
Usage examples
-
TIMEVALUE("1:23:45") -
TIMEVALUE(tableA.fieldB)
Syntax
TIMEVALUE ( time_text )
-
time_text- the string representing the time.
Returns
number - the time in days given the time string.