Calculation can be problematic if you want to use Excel to add times that exceed 24 hours, the limit for one day. Since we formatted Excel to display a time, it ignores the new day resulting from calculation and displays only the time on the new day. In other words, it only displays the part of the total that is greater than 24. Excel actually performed the calculation correctly, but the result is not displayed correctly.
So, if you want to add values that exceed the 24-hour limit, you need to open the “Format Cells” window again. Once there, choose “Custom” from the list. Under “Type,” enter “[hh]:mm”. This creates a format with two-digit hour and minute displays (a leading zero is inserted for a single-digit value). The square brackets ensure that the hours are counted even though the limit for a new day has theoretically been reached.