View Single Post
  #2   Report Post  
Ragdyer
 
Posts: n/a
Default

This is for display only:
With seconds in A1:

=INT(A1/60)&" Min "&MOD(A1,60)&" Sec"
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"anonymous" wrote in message
...
I need a formula which converts seconds to minutes and seconds.

TY for your help. Happy Holidays.

Chris