If you can't reformat your :20:30 it may be text, you could perhaps
convert in another column, e.g. in B1

=(0&A1)+0

format as h:mm:ss and copy down column. If you want to use these values
to replace your originals, copy column then use Edit Paste Special
Values to replace


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