convert seconds to minutes and seconds

[Guest]

What is the formula to convert seconds (89 seconds) to minutes and seconds
(1.29)?

Thanks

 

[Frank Kabel]

Hi
=A1/(24*60*60)
and format as time (hh:mm:ss)

 

[Ron Rosenfeld]

What is the formula to convert seconds (89 seconds) to minutes and seconds
(1.29)?

Thanks

If you want to keep it in that decimal format, then:

=INT(A1/60)+MOD(A1,60)/100

and format as a number with 2 decimal places.


--ron