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?

user_5632629 · Answer

try like this:

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

user_17070115 · Answer

scrnsht

Select this box were my mouse is at, then time will add up over 24 hr. (it's in dutch)

user_14463268 · Answer

Click on Format, select Number, then "More Formats" (at the bottom) and click on "Custom number format" Now enter "[hh]:mm:ss" or "[hh]:mm" as preferred.

Source: https://spreadsheetpoint.com/add-time-in-google-sheets/#Showing_Time_in_More_than_24_Hours_Format

Calculating time above 24 hours in Google Sheets

3 Answers