TIMEVALUE

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

Syntax TIMEVALUE ( text )

Argument	Description
text	A time in text format.

Examples This function returns .07:

TIMEVALUE("1:43:43 am")

This function returns .59:

TIMEVALUE("14:10:07")

See Also HOUR, MINUTE, NOW, SECOND, TIME