TIMEVALUE

Description

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

Syntax

TIMEVALUE ( text )

Parameter 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