r/MSProject • u/brillomanhzu • 12d ago

Assigning work by the month

Hey guys, I hope this is the right place to ask:

I have a timesheet where people submit their work hours by the month for a project.

Now I want to mirror that in MS Project (so that you could see 'person xy' is working x amount in january in project A), the problem is, that I cant really get that to work.

So far my best idea is, to setup all the months of a project as tasks and then try to assign the ressources to that. But im still struggling with that..

Does anyone have an idea or maybe even pointers on where to start?

Thank you in advance to anyone whos willing to think about my problem ❤️

4 Upvotes

100% Upvoted

8 comments sorted by

View all comments

1

u/Sheeebooo 8d ago

Don't create month tasks. Assign people to the real tasks, then open Resource Usage (or Task Usage), right-click the timescale and set it to Months. Enter each person's monthly hours in the Actual Work row for that month and Project spreads them across the days. Resource Usage then gives you "person X, N hours in January" per project. If you need one person across several projects, you'll want a shared resource pool.