Forum Discussion

chris3006's avatar
chris3006
Copper Contributor
Jan 05, 2024

Total Time

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

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

Resources