Convert Seconds to Min:Sec

Hi

I've been looking for ages now and just can't work it out. How can I get numbers to convert seconds into min and seconds???

For example:

A1 = 200 (sec)
A2 = 3:20 (min:sec)

Thanks in advance!

Macbook 2.16 2GB, Mac OS X (10.6.4)

Posted on Jan 16, 2011 1:31 PM

Reply
4 replies

Jan 16, 2011 2:38 PM in response to Sathers

Easiest way is to have A1 be a duration.

In A1 enter 200s, this enters a duration of 200 seconds in the cell.
In A2 enter =A1

Format A2 as a duration showing minutes and seconds. Select A2, click on Inspector button, find Cells, and change the format to Duration and set the specifics of minutes and seconds by using the Units slider and the Format pull down. If done correctly, A2 will display 3:20.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Convert Seconds to Min:Sec

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.