Convert seconds to minutes

[Suresh]

hi all,
I have a excel sheet in which all the values in a column are in seconds. Is
there a way in which i can convert all the values in that particular column
into minutes.

Regards
Suresh

 

[Peo Sjoblom]

Divide by 86400 then format as [mm]:ss

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[Bob Phillips]

Divide by 60 and format to as many decimal places as you want.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Suresh]

thanks 4 u prompt reply.
However my problem is
EX
300
600
900
1200
1500
Now this Column should be come converted into
5
10
15
20
25
is this possible??

 

[Pete_UK]

If you want to do it to all the values in that column in one go, then
enter 60 into a blank cell somewhere and click <copy> on that cell.
Then highlight your data containing the seconds and click Edit | Paste
Special | Values (check) and also check Divide, then OK and <Esc>.

Hope this helps.

Pete

 

[CarlosAntenna]

Place the number 60 in a blank cell anywhere on your worksheet.
Copy this cell, then select the cells you want to convert, right click on
the selected range > Paste Special > divide.