Tip: You can also add up times by using the AutoSum function to sum numbers. Select cell B4, and then on the Home tab, choose AutoSum. The formula will look like this: =SUM(B2:B3). Press Enter to get the same result, 16 hours and 15 minutes.
How do I sum time in HH mm SS on Excel?
The cell receiving the entries is formatted in [hh]:mm:ss, and the entries are in the hh:mm:ss format. The equation is =SUM (C2:C11).