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

    This function returns the decimal number for the 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 decimal value.

    Examples

    TIME(A1,B1,C1)

    TIME(R1C1,R1C2,R1C3)

    TIME(12,0,0) gives the result 0.5

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

    Version Available

    This function is available in product version 1.0 or later.

    Note: If a user uses LegacyBehaviors.CalculationEngine, TIME 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

    HOUR | MINUTE | DAY | NOW | TODAY | Date and Time Functions