Then right click the newly inserted column and select ‘Customize Fields’. Then select field name as ‘Number 2′ and assign title as “Elapsed Days”.
HOW TO CALCULATE PROJECT ACTUAL COMPLETION PERCENTAGE HOW TO
How to do it: In MS Project, right click any column and select insert column. This is required to calculate the percentage. Syntax: ProjDurConv( expression, durationunits )įormula Explanation: ProjDurConv is an available function in MS Project to convert the duration in to Days(pjdays) or Hours(pjhours) or minutes or in any other available format.īased on the start date of the project and the status date, calculate the days elapsed. In the next section click ‘Use Formula’ and then click OK.įormula: Val(ProjDurConv(Duration, pjdays)) On the custom attributes click on the radio button ‘Formula’ and type in the formula as below. Then select field name as ‘Number 1′ and assign title as “Duration in Days”. MS Project stores the duration in minutes, so in order to use the duration in days in our calculations create a customized number field and name it as “Duration in Days”.
In this tutorial I will explain how to create a customized field to capture planned % complete to compare it against the actual % complete. In MS Project there is no default field available to calculate the Planned % complete or the Baseline % completed.
0 kommentar(er)
