TIME Function in Excel converts supplied Arguments Hours, Minutes and Seconds into an Excel time.
Syntax for TIME Function in Excel:
TIME (hour, minute, second)
Hours, Minutes and Seconds are the arguments passed to the Excel TIME function.
Example of TIME Function in Excel:
Formula
- In row number 2 the hour value is less than 12 so TIME Function identifies it as AM
- In row number 3 the hour value is greater than 12 so TIME Function identifies it as PM
- In row number 4 the seconds value is -70 so -70 seconds is subtracted from 7:06:00 AM so the resultant value will be 7:04:50 AM
- In row number 5 the minutes value is 70,so minutes the value is rolled over hours and the output will be 9:10:00 AM
Result: