I am intrigued that you say that I replied incorrectly.

The person who said that you were formatting the cells as [mm.ss] was
yourself (or if not you, the person of the same user name who started the
thread). You'll see it in the quoted material below, but I'll repeat your
words for clarity:
"I first formatted the cells to [mm:ss]"

I'm glad that you got the answer you wanted with [h]:mm:ss as hours minutes
and seconds, but when you originally asked the question you gave the
impression that you wanted the answer in minutes and seconds when it went
beyond an hour, which is why you were given the suggestion to format as
[mm]:ss. In adding your examples (in another branch of this thread) of
48:36 and 45:25, [mm]:ss would show 94:01 for the sum, instead of the
1:34:01 that you will get from [h]:mm:ss. Use whichever you prefer.
--
David Biddulph

Enigman wrote:
Hey David. Thanks for the suggestions. But you replied incorrectly.
You said I was formatting the cells as [mm.ss] but that is wrong. I
was formatting the cells as mm:ss. But I played around with this
again based on your ideas and Luke M.'s too and found the solution.

I reformatted all three cells using [h]:mm:ss and I input my minutes
and seconds using a "0" in front of my minutes for the hours. These
two changes solved my problem.

Thanks for the help.

"David Biddulph" wrote:

[mm.ss] is not a valid format (and Excel should tell you so, so it
isn't clear what you've actually done).
[mm]:ss is what is usually recommended.
You'll also need to make sure that you've got data in minutes and
seconds, not hours and minutes which you're putting in at the
moment. Other messages recently have explained how to deal with
that problem. --
David Biddulph


"Enigman" wrote in message
...
I have encountered a problem I cannot fix. I have a spreadsheet
where I want
to input several cells with minutes and seconds and then total them
up in the
bottom cell. ex. I first formatted the cells to [mm:ss]. The
problem is whenever I input minutes and seconds in any one of the
cells formatted in this manner, the cell displays the wrong info.
In this example, when I input
[48:55] the cell displays [55:00]. If I input [46:37] it displays
[37:00] but
in the formula bar it displays [1/1/1900 10:37:00 PM] without the
brackets.
Stranger yet, if I cursor back to the cell and recheck the
formatting, Excel
changed the format to [h]:mm:ss and yes, it includes the brackets
around the
"h"

This is driving me nuts. Can it be fixed? Please advise.