I have a list of employee login/logout times that currently are in tw
columns. The employee has a shiftstart, firstbreaklogout
firstbreaklogin,lunchbreaklogout, lunchbreaklogin, secondbreaklogout
secondbreaklogin, and shiftend time. I need to be able to alig
horizontally into 8 columns the employees login/out times by date.
Date
06/02/04 8:15AM 9:47AM
06/02/04 10:00AM 12:01PM
06/02/04 12:45PM 2:35PM
06/02/04 2:45PM 4:45PM
06/03/04 8:15AM 9:45AM
06/03/04 10:01AM 12:00PM
06/03/04 12:46PM 2:30PM
06/03/04 2:45PM 4:45PM
06/04/04 8:16AM 9:59AM
06/04/04 10:15AM 12:02PM
06/04/04 12:45PM 2:34PM
06/04/04 2:45PM 4:46P

--
Message posted from http://www.ExcelForum.com

Take a look at DataText To Columns

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"caseyoconnor10 " wrote in
message ...
I have a list of employee login/logout times that currently are in two
columns. The employee has a shiftstart, firstbreaklogout,
firstbreaklogin,lunchbreaklogout, lunchbreaklogin, secondbreaklogout,
secondbreaklogin, and shiftend time. I need to be able to align
horizontally into 8 columns the employees login/out times by date.
Date
06/02/04 8:15AM 9:47AM
06/02/04 10:00AM 12:01PM
06/02/04 12:45PM 2:35PM
06/02/04 2:45PM 4:45PM
06/03/04 8:15AM 9:45AM
06/03/04 10:01AM 12:00PM
06/03/04 12:46PM 2:30PM
06/03/04 2:45PM 4:45PM
06/04/04 8:16AM 9:59AM
06/04/04 10:15AM 12:02PM
06/04/04 12:45PM 2:34PM
06/04/04 2:45PM 4:46PM


---
Message posted from http://www.ExcelForum.com/