HR Roster , Attendance , Shift Excel Cleanup

My HR workbook combines roster, shift, and attendance sheets that no longer follow the sample template I issued to the team. I need the file brought back to a clean, analysis-ready state and I need it fast.

The first pass must focus on the roster data, but the same rules then apply to the shift and attendance tabs so the whole workbook ends up consistent. Every date should appear in a single standard format (DD/MM/YYYY), all columns must sit in the exact order and naming convention used in the template, and the finished sheets should carry intuitive conditional-formatting cues that instantly flag late arrivals, missing clock-outs, or blank mandatory fields.

Deliverables
• One Excel workbook matching the template structure, fully cleaned and free of duplicate or corrupted rows.
• Applied date-format correction, column realignment, and colour-coded conditional rules as described.
• A short change log or comments sheet summarising any assumptions or transformations for audit purposes.

Turnaround is ASAP; once the file passes a quick spot-check on my side the job is complete.