Projecting 20 per cent Delay in Ms project

Hi everyone, 

I have been asked to create a programme projeting 20% longer duration than original duration in Ms-project. I have to show finish date of all activities with longer duration in a new column. What would be the formula or any way to do this? Your help is much appriciated.

Thanks 

Aarya

Microsoft Project
N
Nagendra Aryal 👤 Member for 6 years 11 months
· Permalink

Hi Alexandre,

That was the thing I was looking for. It did work perfectly. I really appriciate your help. Many thanks 

Nagendra 

N
Nagendra Aryal 👤 Member for 6 years 11 months
· Permalink

Hi Alexandre,

That was the thing I was looking for. It did work perfectly. I really appriciate your help. Many thanks 

Nagendra 

A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months
· Permalink

Hi Nagendra,

I have created the following task custom fields with formulas:

a) Duration1 = [Duration] * 1.2 ; (decimal dot or comma depending of MS Windows regional settings)

b) Finish1 = ProjDateAdd([Start];[Duration1];"Standard") ; presuming your project calandar is "Standard"

I do not know how to reschedule le project's tasks with the Finish1 dates instead of the regular Finish dates; a VBA script would certainly be used to do so.

Alexandre

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts