Skip to main content

TIME

Use the TIME function to create a time value from hour, minute, and second values, which can be literals, fields, or formulas that return Number values.

Use

TIME( hour, minute, second )
Create a time from the hour, minute and second.

ParameterRequiredDescription
hourYesthe value of the hour (0 to 23)
minuteYesthe value of the minute (0 to 59)
dayYesthe value of the second (0 to 59)

ReturnsTime

Example

This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.

ON THIS PAGE