Others

Show Monthly Work Hours in Microsoft Project Task Usage

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

Display total project work hours by month in Microsoft Project.

Show Monthly Work Hours in Microsoft Project Task Usage
Product
Microsoft Project
Device & OS
not provided
Scenario
Task durations are entered in hours, and the user wants to see monthly work totals.
Observed behavior
Task Usage displays month headings, but no work values appear in the timephased area.
Before you start

Check whether the hours you entered represent task duration or actual work effort; Microsoft Project treats these as different fields. Confirm that tasks have scheduled dates within the months you want to review.

Solution 1Recommended

Enter Work and Assign Resources to Show Monthly Hours

Use this approach when Task Usage shows month headings but no timephased work values.

Duration measures the working time over which a task is scheduled, while Work measures effort. Project relates work, duration, and assignment units, so entering a duration in hours does not necessarily create the work values you expect.

1
Add the Work column

Open View > Gantt Chart. Right-click a column heading, select Insert Column, and choose Work.

2
Enter task effort

Enter the expected effort in the Work column for each relevant task, using values such as 8h. Review the task dates and duration after making changes.

3
Assign a resource

Select a task and open Resource > Assign Resources. Assign an appropriate resource and check its assignment units; repeat for the other tasks. If you only need a placeholder, create and assign a dummy resource.

4
Open Task Usage

Select View > Task Usage. If Work is not displayed on the right, right-click the timephased grid and select Work from the available detail fields.

5
Set the monthly timescale

Right-click the timescale above the right-hand grid, select Timescale, and set a visible tier to Months. Scroll to the scheduled dates to review work hours by month.

Review assignment settings: Resource units, calendars, task type, and scheduling settings can affect how work is distributed across months. Check these settings if the totals differ from your expectations.
Free Microsoft Office alternative

Summarize Project Hours in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar interface for reviewing project-hour data in spreadsheets. Move exported or copied data into WPS Spreadsheet for monthly summaries; it does not fix Microsoft Project or replace its resource scheduling.

Summarize copied project hours by month with spreadsheet formulas or pivot tablesOpen and edit Microsoft Excel XLSX files for easier data migrationUse a familiar spreadsheet interfaceWork with a free, lightweight office suite
QA img-9

Frequently Asked Questions

Why does Task Usage show months but no hours?

The timescale may be visible even when tasks have no timephased work to display. Check the Work column in View > Gantt Chart, assign resources where needed, and make sure Work is selected in the Task Usage grid.

Is task duration in hours the same as work?

No. Duration is the working time over which a task is scheduled; Work is the effort performed. Assignment units and scheduling settings affect the relationship between them.

Do I need to assign a resource to every task?

For a Task Usage view based on timephased assignments, assigning a resource can make the work distribution visible. You can use a dummy resource through Resource > Assign Resources if you do not need to track a named person.

How do I change the Task Usage view to show months?

In View > Task Usage, right-click the timescale above the grid and select Timescale. Set a visible tier to Months, then scroll to the dates covered by your tasks.