TIMEVALUE(time_text)

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:

Other date functions