Excel Specialist Needed to Automate Attendance Register with Department & Contractor Reports

We are looking for an experienced Excel expert to help us enhance our existing employee attendance register. The Excel sheet contains check-in/check-out times and blank fields for absent days.

✅ Scope of Work:
Add a column to automatically determine Present or Absent based on check-in/check-out data.

Create summary columns showing total days present and absent for each employee.

Generate reports showing:

Number of present employees by department

Number of present employees by contractor

Absentees by department and contractor

Optionally, create a pivot table for dynamic reporting.

? Our Data Includes:
Employee Name / ID

Department

Contractor Name

Daily Check-In and Check-Out Times

? Ideal Candidate:
Expert in Microsoft Excel formulas and data analysis

Experience with attendance or HR-related data is a plus

Able to deliver clean, automated, and user-friendly solutions

⏳ Timeline:
Looking to get this done as soon as possible.

? Attachments:
Will share the Excel file upon hiring.

Please share examples of similar work you've done or explain how you plan to approach this task.