Hello,
I have created a timesheet to help my management team better track arrival times and the amount of time spent on lunch breaks. This info can (somewhat) be pulled from the electronic timeclock system we all use, however, none of the reports pull out in a format that can show the results I'm looking for, and usually require a manual count of schedule deviations. Corporate likes our employees to be fairly exact to their schedule and they look for punches that are 3 minutes, or more early, and 3 minutes, or more, late.
I've got the scheduled and actual arrival times, as well as the scheduled and actual lunch durations calculated, and need the punches, the scheduled times and the calculations to display in hrs/mins (done). I'm almost ready to release this thing, but in the top right corner of the sheet, I have totals to give a quick count of late or early arrivals.
The late arrivals (more than 3 minutes late) were easy to count. I’m having difficulty in counting the arrivals that were more than 3 minutes early. It seems that the negative time is much more difficult for excel to work through, but I could be wrong on that.
I’d like some help figuring out how to count the arrivals that were 3 minutes, or more, early and the lunches that ended 3 minutes, or more, early. I want this count to appear in Q4 (arrival compliance) and T4 (lunch compliance). Thank you.
2014 Schedules and Discrepancies - Example.xlsm
Bookmarks