Employee Schedule Tracking Spreadsheet Creation

Job ID: 39316442

Budget: $10 – $30 USD

I'm in need of a user-friendly Microsoft Excel spreadsheet that can help me track employee schedules. The main requirements include:

- Assigning a standard 40-hour schedule to each employee.
- Easily identifying employees who are working less than 40 hours.

This will allow me to assign these under-scheduled employees to cover open posts without incurring overtime costs.

In terms of specific features, I want to highlight employees working less than 40 hours using:
- Conditional formatting
- A separate summary sheet
- Color-coded cells

Given my advanced level of Excel experience, I'm looking for someone who can create a highly functional, efficient spreadsheet that meets these needs. Prior experience with Excel and creating such spreadsheets is highly desirable.