Overview
Syntax | TIME(Hour,Minute,Second) | Returns the specified date and time. The date is the current date of the system. |
Parameter 1 | Hour | The Hour parameter can be a number between 0 and 23 |
Parameter 2 | Minute | The Minute parameter can be a number between 0 and 59 |
Parameter 3 | Second | The Second parameter can be a number between 0 and 59 |
Notes
The function supports three numeric or text parameters for extracted data.
The function supports three numeric parameters for real-time data.
Example
Formula | Result | Note |
TIME(14,40,0) | 2:40 PM | |
TIME(19,43,24) | 7:43 PM |
