SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / TIMEVALUE
In This Topic
    TIMEVALUE
    In This Topic

    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

    See Also