Hi,

I have a Excel file with time values in a number of columns. The times are
in hh:mm (04:03) format but should be in mm:ss (04:03) format.

In other words, whenthe times were first entered they were put in as 04:03
and formatted as hh:mm. They should have been formated as mm:ss

When I try and change the format to mm:ss I get 03:00, I want 04:03

I hope this makes sence.

Thanks for your help.

Killian