Convert seconds to minutes

S

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
 
B

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)
 
S

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??
 
P

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
 
C

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.
 
Top