Skip to main content
Version: Streamsheets 2.5

TIMEVALUE

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

Syntax

=TIMEVALUE(TimeText)

Arguments

NameTypeDescription
TimeTextStringA text which represents a time value.

Return

A serial number value which corresponds to specified time.

Examples

FormulaResultComment
=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.