Sign up for free
Functions

TIMEVALUE

Converts a text string representing a time to a decimal number between 0 and 1, where 0 represents 00:00:00 and 1 represents 24:00:00 (or 00:00:00 next day).

Parameter List

Syntax
TIMEVALUE(time_text)
time_text

A text string representing a time. For example: "3:30 PM", "15:30:00", "3:30", A1.

More details

TIMEVALUE converts time text to a decimal fraction of a day. For example, "12:00:00" becomes 0.5 (half a day). The text can include hours, minutes, and seconds in various formats. Returns #VALUE! error if the text cannot be interpreted as a valid time.

Examples

TIMEVALUE() returns 1