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

N
Nagendra Aryal 👤 Member for 7 years

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 7 years

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 6 months

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

Featured Partner

Top Posters

Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts