Gornish helfen, as my grandmother used to say :-).


----- original message -----

"Evan" wrote in message
...
Thanks so much everyone for your responses. I actually found the answer
how
to convert seconds to "mm:ss" format. It works so beautifully that I want
to
share,
Please see:
The problem you are experiencing is A1/24 results in hours. Likewise,
A1/24/60 results in hours, and A1/24/60/60 results in seconds. Therefore,
you
want the following function:

=TEXT(A1/24/60/60, "mm:ss")


http://ask.metafilter.com/35607/Very...ion-ever-asked