Hi! I was making a schedule for a Project and after completing the scheduling - I find that the Total Work Hours (shown in the first line Summary) is not correct. The Values are like this: Start Date: 7/15/2004; End Date: 6/16/2005; Duration (In Hrs): 1928; Work (In Hrs):5731. Now this WORK shown - calculated automatically - is wrong. It should be 3803 Hours as per the total of all the "Work Hours" of individual tasks. Why is it showing 5731 then? Curiously on simple mathematics it will be found that - theis figure 5731 = 1928(Duration) + 3803(Actual Work hours of all tasks). My query is
1) Why is it showing this figure of 5731 where as it should be 3803 Hours?
2) What is the solution to correct the same?
I am attaching the MPP file too for your reference.
Do let me know ASAP as I am already delayed.
Mantosh Singh..
Saving Changes...
Sort By:
Andy JordanPresident| Roffensian Consulting S.A.Cherry Grove, AB, Canada
I opened the MPP, it showed 3,803 hours.
I have experienced some interesting and undocumented Project features when you modify resources on tasks, but usually with effort driven tasks (which I see most of yours are) the error is in the way that Project adjusts the duration, not the work itself.
Sorry I can't be more help, but I couldn't see the problem that you describe.
Hi Andy! Gee Thanks for the input. But then this is strange since I am seeing 5731 Hours as WORK in the same File that I am opening here. Whereas it should be 3803Hours as I presume you are seeing there! How can that be I wonder? Any explanation? Is there some initial setting that needs to be changed? Which version of MPP are you using? Perhaps there may lie the problem. But still...
I get your point of how the Duration changes on resource allocation. But could you be more elaborative on the exact problem that you have found in the same? Saving Changes...
Andy JordanPresident| Roffensian Consulting S.A.Cherry Grove, AB, Canada
There are a few settings that impact the amount of work in Project - typically in the Calendar Tab of Options, but if you have effort driven tasks then this shouldn't change the amount of work - it would in fixed duration type projects, but you don't have that.
As for version, I am on 2002 Standard.
The problem that I have seen involves multiple resources on a task, it's a little complicated, but I'll try and explain. If you have an effort driven task that will take 30 days and it has two people on it, one at 50% and one at 25% then the duration will be 40 days - no problem. If you then add a 3rd resource at 75% then the duration should become 20 days, but it doesn't always - sometimes it's OK, sometimes not. The only way I have been able to consistently prevent the problem is to delete the resources and then add them back one at a time.
I have attached a html export file for the task name and work that I see when I open your file - maybe you can compare with what you are seeing and identify the difference. Saving Changes...
There is a workaround to your problem by creating a new summary task:
1) insert a row above task #2
2) Name your task - 'Project Name'
3) Outdent this new task. This will reduce your work figure to 3,803 hours. You can now safely remove the original summary task Saving Changes...
A task has 100 work hours, to shorten the duration, we change the resource working hrs from 8 to 10 and we forseen the change of duation from 12.5 days to 10 days. Thing happend like this, while we does, the gantt chart changed from 12.5 days to 10 days, but the duration field remians and the SF field have one day long. Why? Saving Changes...
