ATTENDANCE FILE
Budget: $30 – $250 USD
MONTHLY I AM RECEIVING EXCEL FILE FOR ALL MY WORKERS ATTENDANCE FOR DUTY ( COMING TIME AND LEAVING TIME) AND I NEED ONE PROGRAM TO COMPARE ALL DATA AND FILTER IT AS FOLLOWING:
1-MAKING LIST FOR STAFF COMING EARLY, LEAVING EARLY, LATE 5 MIN, LATE 10 MIN (OR CUSTOMIZED TIME AS I NEED AT ANY TIME JUST I HAD TO SELECT LATE PERIOD)
2-I NEED IT TO COMPARE BETWEEN ATTENDANCE FILE AND DUTY ROSTER (BOTH ARE EXCEL FILES) TO CALCULATE ABSENT.
3-NEED OPTION TO SELECT DUTY TIME FOR EACH CATEGORY OF JOB (AS WE HAVE MANY DIFFERENT DUTY TIME AND WORKING HOURS)
1-MAKING LIST FOR STAFF COMING EARLY, LEAVING EARLY, LATE 5 MIN, LATE 10 MIN (OR CUSTOMIZED TIME AS I NEED AT ANY TIME JUST I HAD TO SELECT LATE PERIOD)
2-I NEED IT TO COMPARE BETWEEN ATTENDANCE FILE AND DUTY ROSTER (BOTH ARE EXCEL FILES) TO CALCULATE ABSENT.
3-NEED OPTION TO SELECT DUTY TIME FOR EACH CATEGORY OF JOB (AS WE HAVE MANY DIFFERENT DUTY TIME AND WORKING HOURS)