Cell is formatted as hh:ss, when a value is added Excel changes the format to Date Time. Extremely frustrating trying to add times from various projects together.
Kjell Rilbe commented
I think what you mean is that when typing a value into a mm:ss formatted cell, the input is interpreted as hh:mm rather than as mm:ss.
Is this correct?