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

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

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

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

first divide by 60 and then change the format.
--
Gary's Student


"illian Walsh" wrote:

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

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

You need to change the actual values. This conversion is actually
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:ss


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=522892

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

Excelent..........

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

"daddylonglegs" wrote:


You need to change the actual values. This conversion is actually
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:ss


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=522892