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.
Brian J BAKER commented
Go back to the version 2010 for time formats. So much of 365 is ****. Have you started employing people from Chinese CP, with a wish to destroy the west. They are doing a great job.
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?