Is there a formula to AVG a column after I have it converted to min:sec from seconds?

Carrie Holtz

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))

Paul Newcome

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)))

Paul Newcome

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

Carrie Holtz

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

Paul Newcome

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.

Carrie Holtz

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

Paul Newcome

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)))

Carrie Holtz

Thank you very much, Paul.

Paul Newcome

Happy to help. 👍️