Satya's blog

Tuesday, September 04, 2012

Displaying Task with Overall duration

Recently I have got a query from my colleague on MPP that Duration column does not consider Non-working days.
As a part of requirement, they want to display the duration column value considering Non-working days i.e., number of days between start and finish date including non-working time/days.

Here is the procedure to achieve it.

Introduce a Duration custom field. for example let us consider it as Duration1.

Add following formula to the Duration1 field: DateDiff("d",[Start],[Finish])+1 & "days"

Labels: