I have a xls detailing employee time swipes through a card reader. Unfortunately, all of the time data is in a single column. What is the easiest way to calculate hours worked per day? I'm looking at all data for all employees from January 2011 through February 2011, so it's a large set to have to parse manually.
Below is a sample attachec. There are three columns: Card ID, Time, and a column detailing whether it was a swipe into the building or out of the building. What is the easiest way to calculate hours worked per day?
pic.jpg
Bookmarks