Hi
I am exporting data from another application (telephone usage stats) into Excel. The data I export is in mm:ss, i.e. 07:16 however once its pasted into Excel it seems to be reformatted by Excel into 07:16:00. So Excel is converting the minutes into hours.
I want to be able to show this in the format mm:ss but if I do that now Excel shows me 16:00.
Any way around this?
I am exporting data from another application (telephone usage stats) into Excel. The data I export is in mm:ss, i.e. 07:16 however once its pasted into Excel it seems to be reformatted by Excel into 07:16:00. So Excel is converting the minutes into hours.
I want to be able to show this in the format mm:ss but if I do that now Excel shows me 16:00.
Any way around this?