If you like the law or sausage, you should never watch them being made.

Same with my formulas!



"Rick Rothstein (MVP - VB)" wrote:

LOL

Rick

"Dave Peterson" wrote in message ...
Well, I had to fix it a few times to get the quotes right <vbg.

"Rick Rothstein (MVP - VB)" wrote:

Maybe slightly less ugly:
=TEXT(A1/86400,"[m] ""minutes and ""s"" seconds""")

Thanks for noting that. I don't know why, but I keep forgetting that you can force the quote marks around pieces of text in order to escape the characters contained within them... some kind of mental block, I guess.

Rick

--

Dave Peterson

--

Dave Peterson