MS Project Custom Fields

Hi,

I was wondering if anyone had used custom fields to insert a column that tracks the duration of the project in weeks? Please let me know if you have any thoughts or insight on tackling this issue.

Thanks,

You can use a Number field as a custom field with the formula

[Duration]/(480*5)

to convert Duration to the number of weeks (assuming 5 working days in a week). That said, not sure why you would want to do this. I have over 30 years of experience in managing software development projects and I have never seen anyone measure duration in weeks.

Thanks for the rep. I could not figure out a way to make it say "4 weeks", it just shows the number.

Another way you can do this is to go to File > Options > Schedule and set Duration units to Weeks. However, this will change all Duration fields to weeks, and you won't be able to see any durations in days.

Thanks for showing that. I had tried a similar function in the same way that you did this, but it didn't work. I was not aware of ProjDurConv.