Convert 04:03:00 (hh:mm:ss) to 04:03 (mm:ss)

[Guest]

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

 

[Guest]

your 04:03 in hh:mm is actually 0.16875.

first divide by 60 and then change the format.

 

[daddylonglegs]

You need to change the actual values. This conversion is actuall
division by 60 so you could follow this procedure

put 60 in any empty cell
copy that cell
select range of times to convert
Edit > Paste Special > Divide
format times as mm:s

 

[Guest]

Excelent..........

You don't know the time you have saved me. Cheers.