Hi there

There is a solution but the display is hindering any response as it's not
really clear (to me at least) which cells you need to split. Also are the
characters in those cells of a uniform nature i.e. do they always have the
same number of letters and numbers?

The following link is to Google docs where I have placed a blank s/s for you
to copy a row of data with headers to show how it appears.

http://spreadsheets.google.com/ccc?k...UpmZ UE&hl=en

We'll take it from there.

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"PB" wrote:

Hi,

I need a little help. I have time punches that are coming out of a report
into two columns in Excel. I need it to be in four columns so I can analyze
the data better. Any help would be great.

This is how the data is retrieved €“ Time in is in one column and Time out is
in one column.

Last Name First Name Employee Payroll ID Department Pay Group Worked
Department State Day In time Out time Out Punch Type Hours Earnings Code
Doe John 1000001152 11100 123456 CZHRLY 123456 P Wednesday 1/6/2010
6:08 1/6/2010 12:02 LP 5.9
Doe John 1000001152 11100 123456 CZHRLY 123456 P Wednesday 1/6/2010
12:51 1/6/2010 16:05 3.23


Need data to look like this. Four columns for time in, time out, time in,
time out.


Last Name First Name Employee Payroll ID Department Pay Group Worked
Department State Day In time Out time In time Out time Out Punch
Type Hours Hours Earnings Code
Doe John 1000001152 11100 123456 CZHRLY 123456 P Wednesday 1/6/2010
6:08 1/6/2010 12:02 1/6/2010 12:51 1/6/2010 16:05 LP 5.9 3.23


Does anyone have any ideas, I am open to anything.
Thanks
PB