Changing Text to Time in Excel
 

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.

add a helper column

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

and copy down

--
HTH

Bob Phillips

"Chip193" wrote in message
...
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.