today I’m going to show you ProjDurConv function which is very useful in MS PROJECT 2016.
Here is the Scenario. Suppose that I have a simple Project with one Task, and it’s Duration is 5 days:
I want to see Duration in hours as well. So, in my example I should see 40 hours because my Project is set up like:
So 5 days are 5 * 8 = 40 hours.
To show this 40 hours I will use custom field with ProjDurConv function (follow this example step by step):
So, MS Project will convert duration from Days (which is in Duration field), to hours (mention in pjHours).
Now I will show this column in My Gantt Chart:
Now you can see for one Task, Durations in two different Units of Measures.
I will now Define two resources, John and Mary:
Now I will assign John and Mary to the Task (notice That john will be assigned with 50% Units):
As you can see in Work column (which I put in the Gant Chart View), it is 60 Hours (5 days * 8 hours per day for Mary = 40 hours + 5 days * 4 hours per day for John = 20 hours in Total = 60 hours).
OK! Finally I want to see Duration in days but according to work (I want to see how many man days will I spend to this Task). In this case I will use third Custom filed called Man Days:
So, MS Project will convert Work from Hours (which is in Work field), to Days (mention in pjDays).
Finally I will but this custom field on the Gantt Chart:
As you can see, in Man Days I’ve got 7,5 days (60 hours of total work / 8 hours per day shown in Hours per Day = 7,5 days).
As you can see ProjDurConv is powerful Function and I use it a lot.