Calculate Workforce Hours for Multi-Day Tasks in Microsoft Project
Question details
The user needs Microsoft Project to recalculate labor hours correctly when a multi-day task with 10-hour shifts and multiple percentage-based resources is extended from two days to four days.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- A project schedule uses 10-hour shifts and resource assignments including 200% for two employees and 100% each for a mechanic and technician. The user extends a task from two days to four days and expects total work to scale accordingly.
- Observed behavior
- Extending the task duration changes only some resource work values instead of calculating the expected labor hours for all assigned resources.
Before changing calendars or assignments, open the task assignment details and note the task type, the project calendar, and the base calendar assigned to each resource. Also confirm how many hours the project currently treats as one working day.
Create and Assign a Custom 10-Hour Work Calendar in Microsoft Project
Use this when the default project calendar is still 8 hours, because Microsoft Project uses calendar hours and the Hours per day option to convert duration into work.
The expected 80-hour total only appears when the task and resources all use the same 10-hour working calendar and the project's schedule options define one day as 10 hours.
In Microsoft Project, click the Project tab, then select Change Working Time.
Click Create New Calendar, enter a name such as '10-Hour Shift', choose 'Make a copy of Standard', and click OK.
Select all working days, or set the specific shift days, and change the working time to a 10-hour shift such as 08:00 to 18:00 with a one-hour lunch break.
Go to File > Options > Schedule, set Hours per day to 10, and make sure the project calendar uses the new 10-hour calendar.
Open the Resource Sheet, double-click each resource, and set Base calendar to the custom 10-hour calendar. Then reassign or refresh the task assignments.
Extend the task to four days and inspect the Task Usage or Resource Usage view to verify the two 200% employees show 80 total hours.

Verify Task Type and Assignment Behavior in Microsoft Project
Use this when the calendar is correct but duration changes still update only some resource work values.
Review Resource Calendars and Shift Times for Each Assignment
Use this when individual resources use different base calendars or shifts, which causes partial recalculation.
Manage Project Hours in WPS Office as a Free Microsoft Project Alternative
WPS Office does not repair Microsoft Project scheduling logic, but it is a free, lightweight Office alternative that helps you plan resource hours in spreadsheets with familiar Excel formulas and file compatibility. Create your own task duration and labor hours calculator, then share it in .xlsx format without changing tools.
- 1. Download WPS Office: Click the download button on the WPS site and install WPS Office on your Windows, macOS, Android, or iOS device.
- 2. Open WPS Spreadsheet: Launch WPS Office, select Spreadsheet, and open or create a workbook for task names, days, shift length, and assigned units.
- 3. Build a work hours formula: Enter the formula =days*units*hours_per_day in the work column to calculate expected labor hours for each resource and task.
- 4. Save as Excel workbook: Use Menu > Save As and choose Excel Workbook (.xlsx) to keep the file compatible with Microsoft Excel.

Frequently Asked Questions
Why does a duration change not update all resource work values in Microsoft Project?
Usually the task type, effort-driven setting, or resource calendars are not aligned. Check File > Options > Schedule, the task Advanced settings, and each resource's base calendar.
How do I set one project day to 10 hours in Microsoft Project?
Go to File > Options > Schedule and set Hours per day to 10. Then create a 10-hour working calendar under Project > Change Working Time and assign it to the project and resources.
What work total should two employees at 200% produce on a four-day 10-hour task?
With two employees represented by 200% units and a 10-hour project day, the expected work is 4 days × 200% × 10 hours = 80 hours, assuming matching calendars and task settings.
Can WPS Office open Microsoft Project .mpp files?
WPS Office does not open .mpp files. You can recreate the schedule logic in WPS Spreadsheet for labor-hour calculations and save it as an Excel workbook.




