This is regarding Custom Fields in MS Project 2000. I have a requirement of saving history of my project estimates. I perform this by saving my revised estimate as baseline and then saving the new estimate in some custom fields. I am using Duration1-Duration9 fields for saving my BaselineWork values. BaselineWork field is stored in “hrs”, whereas the default unit of Duration fields is “days”. When I enter any value in the custom Duration fields, they get stored as “days”. Have a look at the attached “DurationField.gif” file. In this file, “Final Work Estimate” is a custom Duration9 field. The “Coding” activity has 120 hrs of BaselineWork, but when the same is saved in the Duration9 field, it saves it as 15 days ! It is possible to change the default units of the duration field, but then it will change it for the default Duration field also, which I do not want. Further, if one copies the BaselineWork field and pastes it in the Duration9 field, it pastes it properly as 120hrs, but it is not practical to copy – paste hundreds of fields after a complete schedule is made. I am entering the Duration9 field equal to BaselineWork field through VBA coding. Is there any way to change the units of custom fields? Saving Changes...
I had a go at this and it appears that if you change the default duration units to hours then put the values in whichever Duration field you are using and then change the default back again it seems to work, Project takes the value in whichever is the current default units.
