Find the average of hours, minutes, seconds
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?
Thanks!
Best Answer

You are going to have to convert the times into numbers because Smartsheet is not currently capable of calculating time. There are a number of time based solutions in this thread that should help get you started.
Answers

You are going to have to convert the times into numbers because Smartsheet is not currently capable of calculating time. There are a number of time based solutions in this thread that should help get you started.
Help Article Resources
Categories
Check out the Formula Handbook template!