Skip to content
ProjectControls.com
Microsoft Project

Projecting 20 per cent Delay in Ms project

In the Open Standard
Nagendra AryalMember for 7 years 3 months
Created
3
6
0

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

Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Alexandre Faulx-Briole ·
    #1

    Hi Nagendra,I have created

    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

    Report
  2. 0
    Nagendra Aryal ·
    #2

    Hi Alexandre,That was the

    Hi Alexandre,

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

    Nagendra 

    Report
  3. 0
    Nagendra Aryal ·
    #3

    Hi Alexandre,That was the

    Hi Alexandre,

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

    Nagendra 

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?