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.

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.

Syntax

Arguments

Data Types

Examples

Version Available

See Also