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

Options

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

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

• Options

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

• ✭✭✭✭✭✭
Options

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.

• Options

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

• ✭✭✭✭✭✭
Options

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

• Options

Thank you very much, Paul.

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!