Is it possible to calulate average of a time metric?



I have a column for Avg Handle Time, where each row is formatted as:


How can calculuate the average of multiple rows?

I know with Excel, you can just highlight the whole column, and it'll calculate the average automatically. How would this be done in Smartsheet?

Thanks in advance,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!