Reply To: Extending project duration

Home Forums Microsoft Project Discussion Forum Extending project duration Reply To: Extending project duration

Avatar photoCommunity

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!