Check on excel to highlight overlaps and duplicates or missing

Job ID: 34491611

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
Related categories: PHP Visual Basic Excel