Others

How to Limit a Microsoft Project Resource to 10 Hours per Week

WPS EditorWPS Editor Oct 12, 2026 870 views

Question details

The user needs to restrict a resource's availability to a maximum of 10 hours per week in Microsoft Project to prevent them from being overallocated.

How to Limit a Microsoft Project Resource to 10 Hours per Week
Product
Microsoft Project
Device & OS
not provided
Scenario
Managing team resource scheduling and individual capacities within a project plan.
Observed behavior
Default resource calendars and maximum units do not automatically prevent overallocation without configuring specific 10-hour weekly constraints or capacity settings.
Before you start

Ensure you have access to the Resource Sheet view in your Microsoft Project file and understand whether the team member works fixed daily hours or a flexible schedule before modifying their capacity.

Solution 1Recommended

Create a Custom Resource Calendar for Fixed Hours

Set up a dedicated calendar that only allows the resource to work exactly 10 specific hours per week (e.g., 2 hours per day). Use this if the resource's schedule is rigid.

This method is ideal for part-time resources who work a strict, predictable schedule. By defining exact working times, Microsoft Project will only schedule their tasks during these designated hours.

1
Open the Change Working Time dialog

Navigate to the 'Project' tab on the ribbon and click on 'Change Working Time'.

2
Create a new calendar

Click 'Create New Calendar', name it (e.g., '10-Hour Part-Time'), select 'Make a copy of Standard', and click 'OK'.

3
Adjust the work week details

Go to the 'Work Weeks' tab, click 'Details', select Monday through Friday, and adjust the working times to reflect only 2 hours per day (e.g., 08:00 AM to 10:00 AM).

4
Assign the calendar to the resource

Open the 'Resource Sheet' view, double-click the target resource to open 'Resource Information'. Under the 'General' tab, change the 'Base calendar' to your newly created 10-hour calendar.

Create a Custom Resource Calendar for Fixed Hours
Review Scheduling: Check the Resource Usage view to confirm that Microsoft Project is successfully confining the resource's tasks to the newly defined 10-hour schedule.
Free Microsoft Office alternative

Try WPS Office for Your General Document and Project Tracking Needs

While Microsoft Project handles complex automated scheduling, WPS Office provides a free, lightweight, and easy-to-use alternative for general project management and team collaboration. You can easily build Gantt charts, resource tracking sheets, and project reports using WPS Spreadsheet.

  1. 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your device.
  2. 2. Open a Project Template: Launch WPS Spreadsheet, go to the template library, and search for 'Project Management' or 'Gantt Chart'.
  3. 3. Track Resource Hours: Use the built-in formulas and scheduling templates to easily monitor your team's weekly resource hours without complex configurations.
Fully compatible with Microsoft Excel, Word, and PowerPoint formats (.xlsx, .docx, .pptx).Free, built-in Gantt chart and resource tracking templates available in WPS Spreadsheet.Lightweight installation with a familiar, user-friendly tabbed interface.Seamless migration of your existing project reporting and documentation workflows.
microsoft office alternative - wps office

Frequently Asked Questions

Why is my resource still showing as overallocated after changing their max units to 25%?

Changing the Maximum Units only limits their recognized capacity. If they are already assigned to tasks requiring more than 10 hours of work in a given week, they will instantly show as overallocated. You must run Resource Leveling or manually reduce their assigned work hours for those tasks.

Should I use a custom calendar or adjust Maximum Units for part-time resources?

Use a custom calendar if the resource works specific, fixed hours (e.g., exactly 8 AM to 10 AM daily). Use Maximum Units (like 25%) if they work 10 hours flexibly throughout the standard work week and their exact daily hours don't matter.

Does Resource Leveling automatically fix all overallocations in Microsoft Project?

No. Microsoft Project's resource leveling can delay tasks to resolve schedule overlaps, but it may not resolve all overallocations if project constraints, deadlines, or task dependencies prevent tasks from moving. Manual review in the Resource Usage view is often necessary.