EXCEL expert for Attendance sorting compare filter with other pass record
Budget: $10 – $30 USD
I have 2 excel files of attendance data .
need to compare with the real time pass records ( TIME IN & TIME OUT ) files to check and correct the attendance data's
i have attached excel file .
there will be 2 folders with OFC & OCP
each containing 5 files ,
1 attendance record file
& 4 real time pass record files .
the attendance fil should be compared with the pass record using Filter based on the EMPLOYEE NUMBER and make sure the attendance data is correct .
normally for day shift employees , the attendance data will be correct ,
for night shift employees , who access (TIME-IN) in the evening and exits at (TIME-out) next day morning .
this data sometime will be wrong , or the next following day will be copied with same data . so this need to checked and corrected for all employees as per the attendance record files
need to compare with the real time pass records ( TIME IN & TIME OUT ) files to check and correct the attendance data's
i have attached excel file .
there will be 2 folders with OFC & OCP
each containing 5 files ,
1 attendance record file
& 4 real time pass record files .
the attendance fil should be compared with the pass record using Filter based on the EMPLOYEE NUMBER and make sure the attendance data is correct .
normally for day shift employees , the attendance data will be correct ,
for night shift employees , who access (TIME-IN) in the evening and exits at (TIME-out) next day morning .
this data sometime will be wrong , or the next following day will be copied with same data . so this need to checked and corrected for all employees as per the attendance record files