Show Monthly Work Hours in Microsoft Project Task Usage
Question details
Display total project work hours by month in Microsoft Project.

- 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.
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.
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.
Open View > Gantt Chart. Right-click a column heading, select Insert Column, and choose Work.
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.
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.
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.
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.
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.

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.




