Spread Formula Reference
Formula Functions / Functions T to Z / TIMEVALUE
In This Topic
    TIMEVALUE
    In This Topic

    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.

    See Also

    TIME | DATEVALUE | Date and Time Functions