When you are entering the time, I assume you are entering as 1:45? the issue
is that when you enter time with the colon, it automatically assumes the
first digit is the hours. So in order to enter 1 minute 45 seconds you would
actually need to enter 0:1:45

Hope this helps.
--
John C


"Farias" wrote:

Hi,

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

If i change the cell format to [hh]:mm:ss I get 25:45:00.

I divided by 60 and then changed the cell format to mm:ss but got 25:45,
also tried to divide it by 24 first to try to have only 1:45:00 but instead I
get 01:04:23

I hope this makes sence.

Thanks for your help.