[]
        
(Showing Draft Content)

TIME

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.

!type=note

Note: If a user uses LegacyBehaviors.CalculationEngine, TIME function will return the DateTime object instead of the serial numeric value.

See Also

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