Forum Discussion
Excel converting colon separated numbers to time
It looks like your system time format has changed.
Excel ALWAYS displays a time in the formula bar according to the Long Time format set in your system, regardless of the time format of the cell., just like it always displays a date in the formula bar according to the Short Date format of your system, regardless of the date format of the cell.
So I suspect that your Long Time format was changed from hh:mm:ss to hh:mm:ss AM/PM.
Thank you. I brought that suggestion to our IT manager and he pointed out that change would affect all Excel files. But it only affects files created after yesterday. We have a file from 30 September and the column is displaying correctly. This cell is not supposed to display the time. It's only supposed to display the duration of the call in hours:minutes:seconds.
Can you post a recent screenshot where the formula bar doesn't show AM/PM for a time value?
HansVogelaar It says I don't have permissions to upload images
Jimbo75 sent me a screenshot. I have never seen times in the formula bar of Excel displayed in different formats on the same computer - does anyone else have an explanation?