I am working on a timesheet compliance workbook. My goal is to capture how close people are to their scheduled arrivals and departures. I have created a sample workbook. The workbook has three worksheets.
The first is "Attendance Data". This is meant to represent the data as it is produced by our reporting software. It produces data in four columns. The first is each person, the second the date they logged in or out, the third the time the logged in on each date, and the fourth the time they logged. Note that a person can log out and log in repeatedly on the same date, but I am only concerned about their first login and their last log out of each day.
The second worksheet is for employee "Alvin". The third is for employee "Bruce". Both are the same, they plot out the expected time for the employee to login each day and the time they log out and the difference in minutes.
I need help getting the right data from the "Attendance Data" sheet to the "Alvin" sheet. I need Excel to do a search or match or something that goes like this - first it locates ONLY entries for Alvin, then within that data it ONLY locates entries for a particular date, then it displays the FIRST login for that date. The result would go into cell D2 on sheet "Alvin". Then it needs to do the same again in cell G2, this time for the LAST logout for that date.
I hope this makes sense, I'm happy to provide any clarification that is needed.
Bookmarks