Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the time represented by hour, minute, and second.
Syntax
TIME(hour, minute, second)
Parameters
Name | Required/Optional | Data Type | Description |
---|---|---|---|
hour |
Required |
Numeric |
The hour component. |
minute |
Required |
Numeric |
The minute comonent. |
second |
Required |
Numeric |
The second component. |
Return value
Numeric
Example 1
TIME(15,30,30)
Returns the value representing 15:30:30.
Example 2
FORMAT(TIME(15,30,30),"HH:mm")
Returns the value representing 15:30.
Example 3
TIME(15,30,30) + 8 eh.
Returns the value representing 23:30:30.