TIMEVALUE

Description

TIMEVALUE 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")

Also, see

HOUR

MINUTE

NOW

SECOND

TIME