B
bzbjg
--
The world would be a dark place without light.
The world would be a dark place without light.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Billigmeier
Assume the cell with 536 in it is A1:
To get minutes: =(A1-MOD(A1,60))/60
To get seconds: =MOD(A1,60)
To get minutes: =(A1-MOD(A1,60))/60
To get seconds: =MOD(A1,60)
B
Bob Phillips
=G1/24/60/60
and format as time
--
HTH
RP
(remove nothere from the email address if mailing direct)
and format as time
--
HTH
RP
(remove nothere from the email address if mailing direct)
B
Bob Phillips
or even
=INT(G1/60)&" minutes "&MOD(G1,INT(G1/60)*60)&" seconds"
--
HTH
RP
(remove nothere from the email address if mailing direct)
=INT(G1/60)&" minutes "&MOD(G1,INT(G1/60)*60)&" seconds"
--
HTH
RP
(remove nothere from the email address if mailing direct)
P
Peo Sjoblom
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)
you want to be fancy <bg>
--
Regards,
Peo Sjoblom
(No private emails please)
B
Bob Phillips
it never hurts to be fancy <ebg>
Bob
Bob
Peo Sjoblom said: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)