Find the average of hours, minutes, seconds

Fiona M
Fiona M
edited 09/19/22 in Formulas and Functions

Hi there,

I am having difficulties finding the average of hours, minutes and seconds. I have 12 months of data for timings, and the format is in hours, minutes, seconds how it is in excel - 00:00:00. I have to find the average for each month, for an entire years worth of data, and it gives me an error when I look for the average of each month. I am hoping to not reformat as I have so many figures it would take hours. Has anyone come across this before?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!