TIMEVALUE Function

The TIMEVALUE function is one of the date and time functions. It is used to return the serial number of a time.

Syntax

TIMEVALUE(time_text)

The TIMEVALUE function has the following argument:

Argument Description
time_text A text string that represents a time, e.g. "4:30 PM" or "16:30".

Notes

How to apply the TIMEVALUE function.

Examples

The figure below displays the result returned by the TIMEVALUE function.

TIMEVALUE Function