Others

Calculate Workforce Hours for Multi-Day Tasks in Microsoft Project

Maira MehtabMaira Mehtab Nov 13, 2026 868 views

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.

Calculate Workforce Hours for Multi-Day Tasks in Microsoft Project
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 you start

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.

Solution 1Recommended

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.

1
Open Change Working Time

In Microsoft Project, click the Project tab, then select Change Working Time.

2
Create a 10-hour calendar

Click Create New Calendar, enter a name such as '10-Hour Shift', choose 'Make a copy of Standard', and click OK.

3
Set working hours

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.

4
Set the project day to 10 hours

Go to File > Options > Schedule, set Hours per day to 10, and make sure the project calendar uses the new 10-hour calendar.

5
Assign the calendar to resources

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.

6
Check work after extending duration

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.

Create and Assign a Custom 10-Hour Work Calendar in Microsoft Project
Expected calculation: When configured correctly, two employees assigned at 200% on a four-day 10-hour task calculate as 4 days × 2 employees × 10 hours = 80 hours.
Free Microsoft Office alternative

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. 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. 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. 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. 4. Save as Excel workbook: Use Menu > Save As and choose Excel Workbook (.xlsx) to keep the file compatible with Microsoft Excel.
Free to download and use for everyday project-hour and resource-planning spreadsheetsLightweight and familiar Microsoft Office-style ribbon for quick task and hour calculationsOpens and saves Excel .xlsx workbooks for resource planning and workforce hoursNo need for a Microsoft Project license to create a simple multi-day labor hours calculator
microsoft office alternative - wps office

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.