View Single Post
  #5   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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.