Microsoft Project – convert all durations to days

A client recently asked whether if they had a mixture of days, weeks and hours input into the Duration column, they could quickly change all Microsoft Project durations to days.

To do so, first insert a new Duration column, probably Duration1 unless you are already using that.
Go to the Project tab and click Custom Fields. The Custom Fields dialog box will be displayed.
Microsoft Project durations
Click Formula.
From the Field dropdown, click Duration, then Duration.
Click Ok twice to return to your Entry table.
Select the whole Duration1 column and copy.
Select the original Duration column and paste. All your Microsoft Project durations will be shown in days.
You can then hide the Duration1 column (right-click on column heading and click Hide Column.

Find out more about our Microsoft Project training in Dorset, Wiltshire and Hampshire.

Leave a Reply

Your email address will not be published. Required fields are marked *