Functions
TIMEVALUE
Converts a time string to a fractional serial number
Try it
When to use it
When should I use TIMEVALUE?
Use TIMEVALUE to parse a time string such as 2:15 PM or 14:15:30 into a fractional serial number (0 to 1) so you can perform arithmetic on it.
Used in
Syntax
TIMEVALUE(time_text)Examples
=TIMEVALUE("2:15 PM") // => 0.59375
=TIMEVALUE("14:15:30") // => 0.5940972222222223
=TIMEVALUE("11:59:59.50 PM") // => 0.999994212962963