On Thu, 9 Dec 2004 12:23:03 -0800, "Brian"
wrote:

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