Is there a formula to AVG a column after I have it converted to min:sec from seconds?
I have this formula in to convert seconds into Min:Sec. Now I need to AVG the time in the Min:Sec column. Is there a formula for this?
=INT([1st Response Time (sec)]@row / 60) + ":" + ([1st Response Time (sec)]@row  (INT([1st Response Time (sec)]@row / 60) * 60))
Best Answer

We would just adapt your current formula to only pull the integer and ignore the decimals.
=INT([1st Response Time (sec)]@row / 60) + ":" + INT(([1st Response Time (sec)]@row  (INT([1st Response Time (sec)]@row / 60) * 60)))
Answers

You would need to average the seconds first then convert to mm:ss format.

The 85.11 is the AVG of my seconds. Can I convert this number into mm:ss? Everything I'm trying is not working.

You should be able to use the same formula that you are using to convert the other numbers into mm:ss format that you have posted in your original post.

Thank you, Paul. One last question  is there a formula to remove these extra numbers?

We would just adapt your current formula to only pull the integer and ignore the decimals.
=INT([1st Response Time (sec)]@row / 60) + ":" + INT(([1st Response Time (sec)]@row  (INT([1st Response Time (sec)]@row / 60) * 60)))

Thank you very much, Paul.

Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!