Microsoft Project Member for 18 years 11 months Member for 18 years 11 months Submitted by Tom Boyle on Fri, 2018-08-17 22:12 Permalink Andrew,If you are running MSP Andrew, If you are running MSP 2010+ and are comfortable with vba, you can drop this into a module and run it: Sub DurationDays() Dim t As Task For Each t In ActiveProject.Tasks t.Duration = Application.DurationFormat(t.Duration, pjDays) Next t End Sub (Method is supposedly different with earlier versions, but I have no way to test.) Otherwise, you may be stuck with manually changing the durations, perhaps with a little clicking and dragging. Good luck, tom Log in or register to post comments
Member for 18 years 11 months Member for 18 years 11 months Submitted by Tom Boyle on Fri, 2018-08-17 22:12 Permalink Andrew,If you are running MSP Andrew, If you are running MSP 2010+ and are comfortable with vba, you can drop this into a module and run it: Sub DurationDays() Dim t As Task For Each t In ActiveProject.Tasks t.Duration = Application.DurationFormat(t.Duration, pjDays) Next t End Sub (Method is supposedly different with earlier versions, but I have no way to test.) Otherwise, you may be stuck with manually changing the durations, perhaps with a little clicking and dragging. Good luck, tom
Member for
18 years 11 monthsAndrew,If you are running MSP
Andrew,
If you are running MSP 2010+ and are comfortable with vba, you can drop this into a module and run it:
Sub DurationDays()
Dim t As Task
For Each t In ActiveProject.Tasks
t.Duration = Application.DurationFormat(t.Duration, pjDays)
Next t
End Sub
(Method is supposedly different with earlier versions, but I have no way to test.)
Otherwise, you may be stuck with manually changing the durations, perhaps with a little clicking and dragging.
Good luck, tom