Calculating time above 24 hours in Google Sheets

Question

I have a Google doc that list a bunch of hh:mm durations in a column, like:

1:30  
1:00  
0:30

I am using SUM(D2:D24) to sum it up, and recently the total hh:mm went above 24 hours, so my total hours surpassed 24 hours and resultantly displays 0:15.

On Google Sheets specifically, how would I format the total Cell to allow it to go above 24:00?

Answer 1

try like this:

=TEXT(SUM(A1:A); "[h]:mm")