Calc TIME function

For a full list of available calculation functions, please read What calculation functions are supported.

This article describes the formula syntax and usage of the TIME function.

Description

Returns the serial number of a particular time.

Syntax

TIME(hour, minute, second)

• hour - Required. The hour of the day, from 0 (zero) to 23.
• minute - Required. The minute of the hour, from 0 (zero) to 59.
• second - Required. The second of the minute, from 0 (zero) to 59.

Remarks

• The TIME function returns a decimal number that represents a particular time. For example, TIME(12,0,0) returns 0.5 because it represents noon, which is half of a day.
• If any argument is outside its range, TIME returns the #VALUE! error value.

Example

Errors

For a full list of formula errors, please read Formula errors.

Related functions

• Calc DATE function
• Calc DATEDIF function
• Calc DATESUB function
• Calc DAY function
• Calc DAYS function