Check on excel to highlight overlaps and duplicates or missing
Budget: $30 – $250 AUD
We need a way of checking our Excel timesheet extract for payroll for:
* Convert the decimal to time (i.e. /24 and then apply time format)
* Overlapping times for a day
* Missing timesheet for a day - i.e. if there is a gap between days
This is step 1 - if you can meet our needs we will have other works.
Requirements are:
SORT:
1) Sort order needs to be by Employee
2) Then Date (oldest)
3) Then time (oldest)
4) Highlight where time overlaps for a day for an employee
5) highlight the date either side of where there is a missing date so we know if we need to check a missing timesheet
6) highlight row if it is "Waiting for Approval" or "Rejected"
File Format is xls
* Convert the decimal to time (i.e. /24 and then apply time format)
* Overlapping times for a day
* Missing timesheet for a day - i.e. if there is a gap between days
This is step 1 - if you can meet our needs we will have other works.
Requirements are:
SORT:
1) Sort order needs to be by Employee
2) Then Date (oldest)
3) Then time (oldest)
4) Highlight where time overlaps for a day for an employee
5) highlight the date either side of where there is a missing date so we know if we need to check a missing timesheet
6) highlight row if it is "Waiting for Approval" or "Rejected"
File Format is xls