Understanding Finish Variance and Other Variance Fields in Microsoft Project

Updated for 2026: Clarified explanations of variance fields, baseline requirements, and modern best practices for analyzing variance in Microsoft Project.

Finish Variance in MS Project is one of the most important indicators for understanding how your schedule is performing compared to your original plan. Along with related fields such as Duration Variance and Cost Variance, Finish Variance helps you see whether tasks are finishing earlier or later than expected.

In this article, I’ll explain what Finish Variance means in Microsoft Project, how variance fields are calculated using a baseline, and how to use the Variance table to analyze schedule performance accurately. Don’t forget without a saved baseline, Finish Variance in MS Project and other variance fields will always display zero.

Companion Articles in This Variance Series (Recommended Order): This tutorial is part of my four-part series on tracking schedule and cost variance in Microsoft Project. You can jump straight into the steps below, or follow these companion articles in order if you are setting up your variance views from scratch:

  • Article 1 (Save Your Baseline First): Why Should You Save a Baseline in Microsoft Project? explains how to capture the 20 baseline snapshot fields that power every variance calculation.
  • Article 2 (You Are Here – Understand Standard Variance Fields): Understanding Finish Variance and Other Variance Fields in Microsoft Project covers how Start Variance, Finish Variance, Duration Variance, Work Variance, and Cost Variance work in the built-in Variance table.
  • Article 3 (Build the Custom _Duration View): Creating a Custom Duration Variance View in Microsoft Project walks you through creating the custom _Duration table and Duration Variance view to inspect Duration, Baseline Duration, and Duration Variance side by side.
  • Article 4 (Calculate Percent Variance Formulas): How to Calculate Percent Variance in Microsoft Project (Duration, Cost & Work Formulas) shows how to add custom Number fields (% Dur Var, % Cost Var, and % Work Var) with error-proof IIf formulas and stoplight Graphical Indicators.
Understanding Finish Variance and Other Variance Fields in Microsoft Project

YouTubeWatch the Step-by-Step Video

Prefer to follow along visually? This video demonstrates the exact steps you’ll learn below using Microsoft Project Desktop.

At a Glance: Analyzing Variance in Microsoft Project:

  • The 5 Core Variance Fields: Once you save a Baseline, Microsoft Project calculates Start Variance, Finish Variance, Duration Variance, Work Variance, and Cost Variance.
  • How Variance Is Calculated: Microsoft Project subtracts the Baseline value from the Current Scheduled value (Variance = Current - Baseline).
  • How to Read Variance Numbers: A variance of 0 means the task is on target, a positive variance (> 0) means the task has slipped or overrun its budget (unfavorable), and a negative variance (< 0) means the task is ahead of schedule or under budget (favorable).
  • Where to View Schedule Variance: Switch to the Tracking Gantt view and apply the built-in Variance table to inspect Start Variance and Finish Variance side by side.

Analyze Variance: Understanding the Calculations

If you’ve saved a baseline in your project, Microsoft Project allows you to analyze five types of variance: Duration Variance, Start and Finish Variance, Work Variance, and Cost Variance. The formula for calculating variance is straightforward. Variance equals the difference between the current task value and its original Baseline value, as shown in the following formula:

Variance = Current Value – Baseline Value

For instance, if a task’s current Duration is 15 days, and its original Baseline Duration was 10 days, the Duration Variance is 5 days, indicating the task’s Duration is taking 5 days longer than planned. Keep in mind that a positive variance is bad for the project, while a negative variance is good for the project.

Analyzing Variance in Microsoft Project – Using the Tracking Gantt View

Complete the following steps to analyze variance in your project using the Tracking Gantt view:

  1. Click the Gantt Chart pick-list button in the Task ribbon.
  2. Choose the “Tracking Gantt” view from the menu.
  3. Study the Gantt bars on the right side of the view.
  4. Blue bars indicate completed tasks or non-critical tasks, red bars represent critical tasks that impact the project’s Finish date, and gray bars display the original Baseline schedule.
  5. Compare blue and red Gantt bars against their accompanying gray bars to identify slippage or variances in the project schedule. When a blue or red Gantt bar has slipped to the right of its gray Gantt bar, this means the task is slipping or has already slipped.

Analyze Variance in Microsoft Project – Using the Variance Table

Complete the following steps to analyze variance in your project using the Variance table:

  1. Right-click on the “Select All” button and select the “Variance” table.
  2. Review the Finish Variance column to identify slippage or delays.
  3. Measure the difference between the planned and actual finish dates to determine the extent of schedule slippage.

Analyzing Variance in Microsoft Project – Using the Work Table

  1. Right-click on the “Select All” button and select the “Work” table.
  2. Check the Variance (its real name is Work Variance) column to assess work hour variances.
  3. Compare the planned work hours with the actual hours spent on tasks.

Analyzing Variance in Microsoft Project – Using the Cost Table

  1. Right-click on the “Select All” button and select the “Cost” table.
  2. Examine the Variance (its real name is Cost Variance) column to assess cost overruns or savings.
  3. Compare the planned costs with the actual expenses incurred.

Conclusion

Now you’re equipped with the knowledge to analyze variance in Microsoft Project. If you have questions, please add them in the Leave a Reply section below. Or if you watched the video, add your questions or comments there. Please subscribe to my YouTube channel and leave “Likes” if you like the videos.

Learn More about Variance (Work, Cost and Duration Variance)

If you want to dive deeper into variance reporting and analysis in Microsoft Project, I’ve created additional articles and videos that expand on these topics:

These resources provide more detailed examples and walkthroughs to help you better understand how variance fields work together in Microsoft Project.

Leave a Reply

Your email address will not be published. Required fields are marked *

Are you human? Please solve:Captcha