TIMEVALUE

Converts a text string to a time value.

Syntax:

TIMEVALUE(text)

Example:

TIMEVALUE("12:30")

returns the time value 12:30.

Note that the text string must be a recognisable time format, as specified in the section Date and time functions.