Hello everybody!
I have searched the forum, and Google also, but I was unable to find a solution for what I need (probably because I’m not so good searching or not).
I have a control access table, were all entries and exits are stated. In some days, it can happen that a person leaves the facility more than 1 time (typically is one time for lunch hour, but not always true).
I want to calculate the working hours per day, using the following premises:
On column A, it is the time stamp (date+hour)
On column B, it is the location were the person placed the card
On column C, it is the indication if the person is entering or leaving the facility
As an example, day 20-09
20-09-2012 07:59 POR_T1 IN -> person enter the building
20-09-2012 09:39 POR_BOU1 OUT - > person leaves the building
20-09-2012 10:56 POR_BIN1 IN -> person enter the building
20-09-2012 13:03 POR_T1 OUT-> person leaves the building
20-09-2012 14:08 POR_T1 IN ->person enter the building
20-09-2012 17:48 POR_T1 OUT ->person leaves the building
Now, I want to calculate how many hours was the person inside the building
The attached time sheet, is in “raw format”, meaning that data wasn’t treated yet.
I have tried formulas, but I’m afraid that this will only work with VBA
Thanks in advanced!
Cheers
Bookmarks