The TIMEVALUE function calculates the time code based on a time represented as text. The time code is a decimal fraction ranging from 0 to 0.99999 (0:00:00 to 23:59:59).
For example, the formula
TIMEVALUE("20:15:30")
returns the time code 0.84409722 when formatted as a plain number.
See also: