This function returns the TimeSpan object of the time represented by a text string.

Syntax

TIMEVALUE(time_string)

Arguments

Specify a time as a text string.

Remarks

Use this function to convert a time represented by text to a TimeSpan object in standard format. The time span is an amount of days, hours, minutes, and seconds.

Data Types

Accepts string data. Returns a TimeSpan object.

Examples

TIMEVALUE(B18)

TIMEVALUE(R18C2)

TIMEVALUE("5:29") gives the result 05:29

TIMEVALUE("5:29 PM") gives the result 17:29

TIMEVALUE("17:29") gives the result 17:29

Version Available

This function is available in product version 1.0 or later.

See Also

TIME | DATEVALUE | Date and Time Functions