MS Project Custom Duration Field 1

[BiggerC]

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?

 

[PDQBach]

You'll need VBA to do that.

But ... here's a workaround that sorta works:

1. Set Start1 so it equals Start
2. Set Finish1 to it equals Start + Duration + Number1

Now set your Gantt Chart to use Start1 and Finish1 when drawing the Gantt lines.

I say "sorta" because when you use predecessors and successors the values that Project uses will be based on Start and Finish not on Start1 and Finish1. If you're not using predecessors/successors then this will work just fine.