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