Returns a new time value with the specified hours, minutes, and seconds.
Syntax
 Copy Code
|
|---|
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
Copy Code
|
|---|
=TIME(3,30,0) |
See Also
Function Reference
HOUR Function
MINUTE Function
NOW Function
SECOND Function
DATE Function