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.
SUM (A2: A90)
The [h ]: mm: ss layout need to be an additional value in the personalized checklist under (in Excel 2003)
Format -> cells -> Number tab
category = custom
after that scroll down the "Type" checklist till you locate
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.