计算任务时间 [英] Calculating task time
问题描述
大家好,
我是这个论坛的新人,所以我跳这是提出这个问题的正确位置。
I am new at this forum so I hop this is the correct place to ask this question.
对于一个项目,我有2个截止日期(A和B)。在这两个截止日期之间,发生了3个任务(X,Y和Z)。我希望MS Project根据A和B之间的总时间计算任务X,Y和Z的时间。在这个例子中,X是
时间的50%,Y 30%和Z 20%。当A和B之间的时间等于20天时,X应该需要10天,Y 6天和Z 4天。
For a project, I have 2 deadlines (A and B). In between these 2 deadlines there are 3 tasks that take place (X, Y and Z). I want MS Project to calculate the time for tasks X, Y and Z based on the total time between A and B. In this example, X is 50% of the time, Y 30% and Z 20%. When the time between A and B equals 20 days, X should take 10 days, Y 6 days and Z 4 days.
我的问题:MS Project 2010是否可以使用某些公式计算任务X,Y和Z的持续时间?
My question: Is is possible for MS Project 2010 to use some formula to calculate the duration times of tasks X, Y and Z?
感谢您帮助我!
干杯,Koen
推荐答案
Hi Koen,
Hi Koen,
不幸的是,持续时间无法通过公式计算。您最终拥有持续时间自定义字段,但无论如何,公式只能引用它们所附加的行,而不是另一行。您可以执行一些自定义VBA代码,也可以手动设置持续时间。
Unfortunately the duration cannot be calculated by a formula. You eventually have duration custom fields but anyway formulas can only refer to the row they are attached to, not to another row. Either you do some custom VBA code, or you set the duration manually.
这篇关于计算任务时间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!