Skip to main content

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:

ArgumentDescription
time_textA 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