Timesheet: Determining how long employee was onsite each day??

Greetings,
Any ideas on this one would be tremendously appreciated. Can't seem to crack this nut:

End goal: Determine how long an employee was onsite each day within a certain period.
Issue: Data / format of badge report doesn't really lend itself to this. Let's use these two days as an example, where the time/date are in col A and the out/in status are in col. B ...

Column A Column B
1/25/2013
7:56 am IN
11:30 am OUT
12:15 pm IN
5:17 pm OUT

1/26/2013
7:34 am IN
9:15 am OUT
9:36 am IN
12:15 pm OUT
1:10 pm IN
5:03 pm OUT

Any recommendations on building an automated way to determine how long this person was badged in each day??

Hello and welcome to the forum

"We would love to help you with your question, but 1st, please rename your thread to something more meaningful, that actually describes your problem. Many members will look at a thread title, and if it is of interest to them, or falls within their area of expertese, they might only open those threads. also, searching for ""help"" will not turn up too many results that will benifit you, sorry.

Look at it this way...if you typed that title into google, what would you expect to get back?
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title"

Thanks jpmnick

Often, when you copy/paste data to here from a worbook, the formatting is lost and it is very hard to make out the start and end of different data sets.

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.