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