I'll show you the easy and simple way to sum time past 24 hours in Excel. All we really have to do is to change the format of the desired cell.
The quick answer is to use the number format [h]:mm:ss
Below, I will give a more in depth explanation of how this works.
Here, we have a list of start and finish work times stored in Excel. There is also a column which calculates how many hours were worked:
What we need to do now is to find the total number of hours that were worked. To do this, we just need a simple sum formula:
But, since the total number of hours is greater than 24, by 7.5 hours, we get the above result.
What we want is this:
All that we did here was to add the number format [h]:mm:ss to the new cell. Nothing else was changed!
This is all you do:
Download the accompanying Excel workbook if you want to get this spreadsheet.
If you enjoyed the tutorial make sure to follow us on facebook and google plus!
Have a great day!