How to make Duration take resouce's calendar into consideration?

[jackchung]

Hi,

I'm a fairly new MS Project user and in need of some help tuning the Duration column. I have two staff, A and B; A works 2 hours a day and B works 1 hour a day. I have set the "Hours per day" to 2 hours.

Now this works for A who's hours are the same as Hours per day. However, let say I assign a 4 hour task to B, the "Duration" is shown as 2 days instead of 4. The Gantt chart has B's duration correct though.

Is there a way I can make B also has the correct Duration?
I am able to do this by adding an extra custom column and writing my own formula, but it seems rather surprising to me that Project doesn't handle this by default?

Thanks!

Jack

 

[PDQBach]

I understand what you're trying to do.

But I accomplish the same thing a different way and it works well for me.

Your resource who works 2 hours a day (10 hours a week) is more easily handled if you use the standard calendar and then schedule the resource to be available 25% of the time (assuming a 40-hour week).

First, you're going to have to get the resource back to the standard calendar. Easiest way: remove the resource assignments from each task, delete the resource, recreate the resource.

View | Resource Sheet and look at the column Max Units. Set that to 25%.

The other issue you have to deal with is whether the task Type is fixed units, fixed work or fixed duration since Project behaves differently depending on the task Type.

I put up a message about this elsewhere on this site.