# Summing a column in excel that is of custom type h:mm

I am summing a column of personalized type h: mm.

Trouble is, if the complete hrs looks at 24, my SUM resets to 0 and also therefore the last number is not deal with.

I desire the outcome to be like: 75 hrs. Yet given that the outcome resets, I have no suggestion the amount of times it counted previous 24 hrs.

my equestion:

SUM (A2: A90)

1
2022-06-07 15:16:13
Source Share

The [h ]: mm: ss layout need to be an additional value in the personalized checklist under (in Excel 2003)

Format -> cells -> Number tab


after that

category = custom


after that scroll down the "Type" checklist till you locate

[h]:mm:ss


If it is not there you can type it right into the solitary box under where it claims "Type: " on the right-hand man side of the tab.

4
2022-06-07 15:39:00
Source