Find the average of hours, minutes, seconds

Fiona M

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!

Paul Newcome

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.

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time

Paul Newcome

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.

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time