Hello all
I have a daily table that contains employee ids, punch in date, punch out date, punch in time, punch out time as well as other fields.
employees get reimbursed for their expenses so the data I’m given will sometimes have an employee Id more than once. For some reason each expense they enter creates another row and sometimes they enter different punch in time.
I need to verify that multiple employee ids have the same punch in time. If not create some sort of flag that notifies me to look at that entry. Any idea what function can help?