Questions

MS Project 2007 Custom Duration

+
0 Votes
Locked

MS Project 2007 Custom Duration

V0X
I have a project and I wish to increase the duration of a task automatically based on what I set as a customised field.

Example: -

I have a set of delay codes that each equate to a different set of values, 100 = 30, 200 = 15, based on this I have a customised field that does a lookup on this and presents the correct value to the project.

IIf([Text1]="100",30,0) & IIf([Text1]="200",15,0) & IIf([Text1]="300",100000,0)

I also have a duration field that takes the above value and adds it to the duration: -

[Duration]+[Number1]

Now this looks fine but project ignors that field and continues to use the Duration field so I now have two duration fields, the default one and the one I created, I want project to use the one I created or be able to update the default duration field.

Any ideas anyone?