View Single Post
  #6   Report Post  
Bob Phillips
 
Posts: n/a
Default

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.