TIMEVALUE

See also A-Z Spreadsheet Function List

Description Returns a serial number for the supplied text representation of time.

Syntax TIMEVALUE(text)

text is a time in text format.

See Also HOUR , MINUTE , NOW , SECOND , and TIME functions

Examples TIMEVALUE(“1:43:43 am”) returns .07

         TIMEVALUE(“14:10:07”) returns .59