Changing Text to Time in Excel

[Chip193]

I have a large database that is sent to me for anaysis on a regular basis.
My problem is with times. They are sent to me in the for 0122 as text. I
need help converting them to a time that excel can deal with (without
manually fixing them, as there's about 100,000 pieces of data that need to be
updated).

Thanks your your help.

 

[Bob Phillips]

add a helper column

=TIME(LEFT(A2,2),Right(A2,2),0)

and copy down