Spread Formula Reference
TIME
Formula Functions > Functions T to Z > TIME

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

Version Available

This function is available in product version 1.0 or later.

See Also

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