Forum Discussion
chris3006
Jan 05, 2024Copper Contributor
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.