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

Thanks

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Brian" schrieb im Newsbeitrag
...
What is the formula to convert seconds (89 seconds) to minutes and
seconds
(1.29)?

Thanks

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