TIME
Description
Returns the current time based on the specified hour, minute, and second.
Syntax
TIME(
hour
,
minute
,
second
)
- hour: The integer representing the hour.
- minute: The integer representing the minutes.
- second: The integer representing the seconds.
Example
Formula | Result |
|---|---|
=TIME(23,23,59) | 11:23 PM |
=TIME(1,15,99) | 1:16 AM |