Total Time

Copper Contributor

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

1 Reply

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