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.