Find the average of hours, minutes, seconds
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?
Help Article Resources
Check out the Formula Handbook template!