TIMEVALUE

This function returns the decimal number representing a particular time in Excel.

Syntax

TIMEVALUE(time_string)

Arguments

Specify the time as a text string.

Remarks

Use this function to convert the time represented by a text string to a decimal number.

Data Types

Accepts string data. Returns the decimal number that represents the time in Excel.

Examples

TIMEVALUE(B18)

TIMEVALUE(R18C2)

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

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

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

Version Available

This function is available in product version 1.0 or later.

Note: If a user uses LegacyBehaviors.CalculationEngine, TIMEVALUE function will return the DateTime object instead of the serial numeric value. For more details, please refer to breaking changes for legacy behaviors.