how do i convert 536 seconds to 8minutes 56seconds
 

--
The world would be a dark place without light.

Assume the cell with 536 in it is A1:

To get minutes: =(A1-MOD(A1,60))/60
To get seconds: =MOD(A1,60)
--
Regards,
Dave


"bzbjg" wrote:


--
The world would be a dark place without light.

=G1/24/60/60

and format as time

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bzbjg" wrote in message
...

--
The world would be a dark place without light.

or even

=INT(G1/60)&" minutes "&MOD(G1,INT(G1/60)*60)&" seconds"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bzbjg" wrote in message
...

--
The world would be a dark place without light.

Or even =G1/86400 and format as either mm:ss or mm "minutes" ss "seconds" if
you want to be fancy <bg

--
Regards,

Peo Sjoblom

(No private emails please)


"Bob Phillips" wrote in message
...
or even

=INT(G1/60)&" minutes "&MOD(G1,INT(G1/60)*60)&" seconds"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bzbjg" wrote in message
...

--
The world would be a dark place without light.

it never hurts to be fancy <ebg

Bob


"Peo Sjoblom" wrote in message
...
Or even =G1/86400 and format as either mm:ss or mm "minutes" ss "seconds"
if
you want to be fancy <bg

--
Regards,

Peo Sjoblom

(No private emails please)


"Bob Phillips" wrote in message
...
or even

=INT(G1/60)&" minutes "&MOD(G1,INT(G1/60)*60)&" seconds"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bzbjg" wrote in message
...

--
The world would be a dark place without light.