Home › Forums › Discussion › 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!