Search results

I'm having a little difficultly folloiwng the changes. Which column would tell me if they were late or early? Thanks!

Is there a way that we can count anything between 00:01 - 4:00 as an out punch for the previous day? In the case of these three punches, 12/1/2012 21:25 12/2/2012 0:14 12/2/2012 12:49 The middle one of 0:14 would be the "out punch" for the 1st. The last entry would be in true "in punch"...

I noticed I forgot to delete her name after I posted it! Durh... so much for my attempts to protect privacy!

Also, the "Jane Doe" badge swipe report I sent would match the schedule of "supervisor 13"

1) Yes, you can assume that one of those names would be Jane Doe 2) If they are off, and have swipes for that day perhaps we can set the formula to return the word "Unscheduled"? If they were not scheduled for that day I am not concerned with what time they were in the building. Thanks! Lisa

I've modified the schedule spreadsheet so that it only includes the relevant information for the badge swipe process. let me know if you have any questions. https://hotfile.com/dl/188214140/58c6306/Sup_Rotation_Sample.xlsx.html

Faseeh – Thank you for your reply. If I am manipulating this worksheet correctly you would have to enter each day of the month and the corresponding “seq id” at the top of the sheet for the formula to work, correct? It may not save much time since I would have to enter each day of the month...

HAHA! SirJD7 - That sounds like a brilliant solution! I don’t know if my employees would be willing to comply though :P

Sure. https://hotfile.com/dl/187951684/a005acc/Example_Badge_Swipe_Report_Dec_2012.xlsx.html https://hotfile.com/dl/187951684/a005acc/Example_Badge_Swipe_Report_Dec_2012.xlsx.html

I manage a group of exempt level supervisors who do not punch a time clock. Because of time abuse (frequently coming in late, leaving early, etc) HR created an attendance gate for supervisor bonuses. Because they do not punch a time clock the only method I have for validating they were on time...