Watch this video to know about the steps How to add Time in Excel
Use the following custom number formats and the SUM function in Excel:
Hours = [h]:mm:ss
Minutes = [m]:ss
Seconds = [ss]
Create a worksheet and type the below given values. Make sure to use a colon (:) to separate the numbers.
Type the below mentioned formula into cell A4. Excel automatically formats the result correctly .
Excel displays 36:21:51 as the total.