TIME Function Explained
The TIME function in Microsoft Excel returns the serial number of a particular time. It takes three arguments: hour, minute, and second. The hour argument is a number from 0 (12:00 AM) to 23 (11:00 PM). The minute and second arguments are numbers from 0 to 59. The TIME function is useful for calculating elapsed time or adding a specific time interval to a date.
TIME Function Syntax
TIME(hour, minute, second)
- hour: The hour argument is a number from 0 (zero) to 23 representing the hour of the day.
- minute: The minute argument is a number from 0 to 59 representing the minute of the hour.
- second: The second argument is a number from 0 to 59 representing the second of the minute.