TIMEVALUE

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

Syntax

TIMEVALUE(time_string)

Arguments

[Required] Specify a time as a text string.

Remarks

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

Examples

TIMEVALUE(B18)

TIMEVALUE(R18C2)