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




"Suresh" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

[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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

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

"Suresh" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

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

--
Carlos

"Suresh" <[email protected]> wrote in message
news:%[email protected]...
> 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??
>
> "Suresh" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> >
>
>