TIME
Spread WinRT Documentation > Formula Reference > Formula Functions > TIME

Summary

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