SpreadJS 14
Formula Reference / Formula Functions / Date and Time Functions / TIME
In This Topic
    TIME
    In This Topic

    This function returns the TimeSpan object for a specified time.

    Syntax

    TIME(hour,minutes,seconds)

    Arguments

    This function has these arguments:

    Argument Description
    hour Hour as a number from 0 to 23.
    minutes Minutes as a number from 0 to 59.
    seconds Seconds as a number from 0 to 59.

    Data Types

    Accepts numeric data for all arguments. Returns a TimeSpan object.

    Examples

    TIME(A1,B1,C1)

    TIME(R1C1,R1C2,R1C3)

    TIME(12,0,0) gives the result 12:00:00

    TIME(16,48,10) gives the result 16:48:10

    See Also