How could I calculate cumulative hours worked on all tasks from project start date to current date (status) to get a comparison between projected hours worked (baseline) and actual hours worked (tracking)?
-
In general, or in a specific tool?– ZsoltCommented Oct 26, 2015 at 8:19
-
This is known as variance; the technique is simple, and you've outlined the best way. Assuming you have projected hours and that you've tracked actual hours, subtract actual from projected. Perhaps I'm missing some subtlety?– MCWCommented Oct 26, 2015 at 10:38
-
1I'm not sure, we'll need some clarification form OP– ZsoltCommented Oct 26, 2015 at 11:20
-
MS Project 2013– TandemDCommented Oct 31, 2015 at 20:50
Add a comment
|
2 Answers
Update the status date to the appropriate date. Open up the "Work Variance" column. Read the value at whatever level of the schedule you are analyzing.
This assumes you loaded planning values for work and you load actual hours in against each work package.
answered Oct 26, 2015 at 17:10
Assuming you have a baseline: Make sure the Project summary task is displayed, go to the Task Usage view and add the Cumulative Work and Baseline Cumulative Work field to the timescaled portion of the view.
