Hi,

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:

and:

and:

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):

then:

then:

then:

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.

Regards!