Forum Discussion
Project Percent Complete Formula
I am trying to figure out the formula used for Microsoft Project % Complete rollup so that I can use Microsoft Project in an Excel version. I know that the rollup is not just the average of the tasks...
jacknolan,
At summary level Project calculates percent complete as:
% Complete = (sum of subtask actual durations)/(sum of subtask durations) *100%
Hope this helps.
John
At summary level Project calculates percent complete as:
% Complete = (sum of subtask actual durations)/(sum of subtask durations) *100%
Hope this helps.
John