Hi,

I got interesting question from one of my Blog Readers:

“Nenad this is very helpful, however, how would you adjust the scenario where the Actual work by John (100%) and Tom (50%) who are two resources assigned to this 5 days of task i.e. planned work will be John (5*8 = 40hrs) and Tom (5*4=20hrs) total work will be 60hrs.
And if John has worked for 60 hrs alone and Tom has worked for 40 hrs but still the work is only 50% done i.e. at 100hrs spent already the % complete is still 50%, but MS Project will default it to 100% complete, so how can I control this in MS Project?”

OK! Let’s go. First I will create a Project with one Task and 5 days duration in MS PROJECT 2016:

Now I’m going to create Resources: John with 100% max capacity, and Tom with 50% max capacity:

Finally, I’m going to assign John and Tom to the Task:

OK! Now I will show Task Usage View, and I will add Actual work fields in it:

If

I now put 60 hours in Actual Work field for John, and 40 hours for Tom I will get:

As you can see, this Task is considered Completed. But that is not what my Reader wants. So instead of that I will do next:

and:

Now I will add the Remaining work in Task Usage view: and I will get:

As you can see:

• John has to work 120 hours to complete the Task, and he worked 60 hours already, but it is only 50% of what he has to do, so Remaining work is 60 hours
• Tom has to work 80 hours to complete the Task, and he worked 40 hours already, but it is only 50% of what he has to do, so Remaining work is 40 hours
• In total, John and Tom have to work 200 hours to complete the Task, and they already worked 100 hours, but it is only 50% of what they have to do, so Remaining work is 100 hours in total

So yes, you can do it, but it has few more steps!

Regards!