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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!