If your times are text strings, hence the leading 0 and the first cell
you wish to change is f8 in the next colum put
=TIME(LEFT(f8,2),MID(f8,3,2),RIGHT(f8,2)) and copy this doen to all the
rows that are effected. If you then select all of them and copy then
past special as values on top of themselves and then copy these values
ontop of the text strings this should sort you out. You can then delete
the extra column
Regards
DAv
--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=560131