How to sum time in excel

To do this yourself, please follow the steps described below;

– Open the desired Excel workbook with some data including entries of time which could be summed up
– Now calculate the sum of these time durations using a simple “=SUM()” formula, as shown in the image below.

– Now we see that we have got the sum, but still it doesn’t look right. This is because by default, excel shows time in the 24 hour format, so no matter what the sum is, whenever the sum goes above 24 hour- mark, it comes back to 0.

– To correct this, let’s go to the cell where the sum is calculated (in our case it is cell “D12”). Right click on this cell, and choose the “Format Cells” option, as displayed in the image below.

– A dialogue box appears. It shows what the current format of the cell is. We can see that currently, the format is in the custom category, and it is in “h:mm” format.

– We need to scroll through these options and select the “[h]:mm” option. Click “OK” once this option has been selected.

– Now we can see the correct summation of the time durations as depicted in the image below.

– Correct time format to show the sum