I am a newbie to VBA.
I need to compare time for each employee from one sheet to the login and logout times on another sheet. This is to ensure that the employee has a job for to cover all time from the begining of his shift to the end of his shift. Anytime there is a gap at the beginning or end i would need to copy that row to a new sheet.
Employees are able to work from one day to the next (night shift). We also have employees that forget to login or logout at times. I would appreciate any help with how this could be done using VBA.
Reply With Quote