They change it from text to a number. You could leave it as text and it
looks right, but you can't add them, add to them etc. You do also have to
format it as mm:ss so that it looks right as well. Actually, I made a slip,
it should be

=--TEXT(A1/1440,"hh:mm:ss")

not

=--TEXT(A1/1440,"mm:ss")

and then format as mm:ss

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"HumingBean" wrote in message
oups.com...
Bob, I deleted the two hyphens between the equals sign and TEXT.
Should I have?

No, it is part of the solution.

Bob, when I add the two hyphens back in the result is a decimal number,
but when I delete them the result is just what I want. What do the
hyphens do?

Thanks.