TIME Function in Excel – Convert Hours, Minutes and Seconds into time in Excel

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

time function in excel 1

  • 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:

time function in excel 2

previous TIME Function in Excel                                                                                                                next TIME Function in Excel