Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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.