Convert Seconds to Min:Sec

Question

Level 1

24 points

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

Answer 1

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.

Reply

Answer 2

Jan 16, 2011 6:17 PM in response to Sathers

Sather,

=DURATION(,,,,A1) will do it. You will need to set the Duration Units in the Cells Inspector if you want a conversion to Minutes:Seconds, etc.

Jerry

Reply

Answer 3

Sathers Author

Level 1

24 points

Jan 17, 2011 3:34 AM in response to KOENIG Yvan

KOENIG Yvan wrote:
I'm sure that spending the wasted to to read *_iWork Formulas and Functions User Guide_* would have give you the answer.

Thanks for this... not being a regular user of numbers (pages does most of what I need) I wasn't even aware of this user guide. Thanks for pointing it out.

Reply

Answer 4

KOENIG Yvan

Level 8

41,819 points

Jan 17, 2011 2:15 AM in response to Sathers

I'm sure that spending the wasted to to read *_iWork Formulas and Functions User Guide_* would have give you the answer.

Yvan KOENIG (VALLAURIS, France) lundi 17 janvier 2011 11:15:13

Reply