Home » Questions » Computers [ Ask a new question ]

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

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

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

Asked by: Guest | Views: 318
Total answers/comments: 1
Guest [Entry]

"The [h]:mm:ss format should be another value in the custom list under (in Excel 2003)

Format -> cells -> Number tab

then

category = custom

then scroll down the ""Type"" list until you find

[h]:mm:ss

If it's not there you can type it into the single box under where it says ""Type:"" on the right hand side of the tab."