TIMEVALUE

Converts time given as text to a corresponding serial number. String to time converter.

Syntax

=TIMEVALUE(DateText)

Arguments

NameDescription
TimeTextA text which represents a time value.

Return Value

A serial number value which corresponds to specified time.

Example

FunctionResultComment
=TIMEVALUE("12:00 AM")0.5The number to the left of the decimal define the days since 1.1.1900. The number to the right of the decimal define the fraction of the day.