安排差异 [英] Schedule Variance

问题描述

 我想知道这个的公式。

 I would want to know the formula for this please.

 我想使用字段[Baseline Start]，[Baseline Finish]，[Actual Start]，[Actual Finish]进行计算。

  I want to use fields [Baseline Start], [Baseline Finish], [Actual Start], [Actual Finish] for my calculation.

我想要计算的是  with formula for方差为=（（（[实际完成] - [基线完成]）/（[基线完成] - [基线开始]））* 100）。我想在"文本"中使用此公式。字段并将其显示为项目中的列。我想
应该使用一些projdatediff或其他格式，因为差异应该以天为单位返回数值，任何人都可以建议格式化这个公式。

How i want to calculate is  with formula for Variance as = ((([Actual Finish]-[Baseline Finish])/([Baseline Finish]-[Baseline Start]))*100). I want to use this formula in the "Text" field and show it as a column in project. I think i should use some projdatediff or other formats because the differece should return number value in days, can anyone advise on formatting this formula.

谢谢

mp

推荐答案

嗨Max_Pin，

Hi Max_Pin,

Project已经为你计算了Finish Variance和Start Variance，所以我不确定你为什么要重新创建这个轮子。尽管如此，回答有关执行日期计算的问题：

Project already calculates Finish Variance and Start Variance for you, so I'm not sure why you are attempting to re-create the wheel. None-the-less, to answer your questions about performing date calculations:

要计算日期之间的差异，您有两种选择：

To calculate a difference between dates, you have two choices:

ProjDateDiff或DateDiff。

ProjDateDiff or DateDiff.

ProjDateDiff允许您计算两个日期之间的分钟数，并指定计算的日历。 如果日期跨越周末，则仅计算工作日。 因此，要计算Finish和Baseline完成
之间的差异，公式将是：

ProjDateDiff allows you to count the number of minutes between two dates and specify the calendar for the calculation.  If the dates span a weekend, it will only count working days.  So, to calculate the difference between Finish and Baseline finish the formula would be:

ProjDateDiff（[Finish]，[Baseline Finish]，"Standard"）/ [Minutes每天]

ProjDateDiff([Finish], [Baseline Finish], "Standard")/[Minutes per Day]

DateDiff函数计算间隔（天，周，月）但不考虑工作时间与非工作时间。 计算Finish和Baseline Finish之间差异的公式为：

The DateDiff function counts intervals (days, weeks, month) but does not take into account working versus non working time.  The formula to count the difference between Finish and Baseline Finish would be:

DateDiff（" d"，[Finish]，[Baseline Finish]）

DateDiff("d", [Finish], [Baseline Finish])

我希望这会有所帮助。

这篇关于安排差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！