TIME

Returns a new time value with the specified hours, minutes, and seconds.

Syntax

TIME( Number hours, Number minutes, Number seconds ) → Time

Parameters

hours

Required. The number of hours in the returned time.

minutes

Required. The number of minutes in the returned time.

seconds

Required. The number of seconds in the returned time.

Remarks

Hours, minutes, and seconds may be any number, they are not limited to the ranges 0…24, 0…59, or 0…60 respectively.

Example

Formula

=TIME(3,30,0)
=TIME(55,0,0)

See Also

Function Reference
HOUR Function
MINUTE Function
NOW Function
SECOND Function
DATE Function