Aligning login logout times horizontally


C

caseyoconnor10

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
 
Ad

Advertisements

B

Bob Phillips

Take a look at Data>Text To Columns

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top