Total Time

[chris3006]

Our annual report generates total time on a fire call, ie: 1:23:18 format.  I want to total the time on calls for the year? cells H11 to H2714.  Auto sum does not work.

Thanks

Chris

[#2]

Try =SUM(H11:H2714) and apply the custom number format [h]:mm:ss to the cell with the formula.