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?
    – Zsolt
    Commented 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?
    – MCW
    Commented Oct 26, 2015 at 10:38
  • 1
    I'm not sure, we'll need some clarification form OP
    – Zsolt
    Commented Oct 26, 2015 at 11:20
  • MS Project 2013
    – TandemD
    Commented Oct 31, 2015 at 20:50

2 Answers 2


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.


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.