TIMEVALUE

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

Syntax

=TIMEVALUE(DateText)

Arguments

Name

Description

TimeText

A text which represents a time value.

Return Value

A serial number value which corresponds to specified time.

Example

Function

Result

Comment

=TIMEVALUE(“12:00 AM”)

0.5

The 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.