Can I convert seconds into mm:ss?

Carrie Holtz

I am trying to convert my seconds into min/sec and can't seem to get any formula to work. Any help would be so great, thanks!

MCorbin

Oops - here it is with your column name:

=INT([Column15]@row / 60) + ":" + ([Column15]@row - (INT([Column15]@row / 60) * 60))

Carrie Holtz

Thank you so much! This worked perfectly!

MCorbin

Try this:

=INT(Seconds@row / 60) + ":" + (Seconds@row - (INT(Seconds@row / 60) * 60))

MCorbin

Oops - here it is with your column name:

=INT([Column15]@row / 60) + ":" + ([Column15]@row - (INT([Column15]@row / 60) * 60))

Carrie Holtz

Thank you so much! This worked perfectly!