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.