View Single Post
  #4   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

=A1/86400

Custom time format the formula cell as:

[mm]:ss

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

TY for your help. Happy Holidays.

Chris