Home › Forums › Microsoft Project Discussion Forum › Extending project duration › Reply To: Extending project duration
You can easily do this with a little help from Excel. Following instructions are on Office 2007.
(1) Copy only the duration column to Excel. (Gantt chart view-> Right Click on the Duration column heading -> Copy Cell)
(2) Paste on an Excel sheet.
(3) Extract the number only. In Excel sheet select Data -> Text to Column -> Delimited -> Delimiter is space
(4) Apply you formula and get new durations
(5) Paste new durations back in MS Project.
Isnt it cool!
Please enter your username or email address. You will receive a link to create a new password via email.