[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.