Project PRofessional 2003 Formual Question

[Bill]

I am using the following formula to get the variance of work to display in
one of our views.

I placed the formula in one of the duration1 field. The formula is

IIf([Actual Work]=0,0,[Actual Work]-[Baseline Work])

Everything works fine except I get the result in days instead of hours.
What do I need to do to get the correct units.

Thanks

Bill

I posted on the old http://support.microsoft.com/newsgroups/default.aspx Not
realizing that it is shutting down.

 

[Mike Glen]

Hi Bill,

Welcome to this Microsoft Project newsgroup

Just multiply the second condition by the number of working hours you have
in a day - the default is 8. You'll have to expriment with brackets to get
it right!

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

 

[JackD]

Put it in a text field and modify it to show hours like this:
IIf([Actual Work]=0,0,([Actual Work]-[Baseline Work])/60) & " hours"

 

[Haris Rashid]

hi Bill,

Here is how you can convert to hours in MS Project:

ProjDurConv(IIf([Actual Work]=0,0,[Actual Work]-[Baseline Work]),pjHours)

The "ProjDurConv" function Converts an expression to a duration value in the
specified units.

However it is better that you use the MS Project field "Work Variance". The
Work Variance field contains "0 hrs" until the work value varies from the
baseline work value, as shown in the Baseline Work field. Microsoft Office
Project 2003 then calculates work variance as follows:

Work Variance = Work - Baseline Work

Another important thing to note is that duration and work are two different
entities. MS Project also provides the duration variance field. The Duration
Variance field contains "0 days" until the duration value varies from the
baseline duration value, as shown in the Baseline Duration field. Microsoft
Office Project 2003 then calculates duration variance as follows:

Duration Variance = Duration - Baseline Duration

Kind regards,

 

[Bill]

Haris,

Thanks for the formula did know that existed. I have one more question....
Is there a reason why on the rollup the units convert back to days?

Thanks

Bill

hi Bill,

Here is how you can convert to hours in MS Project:

ProjDurConv(IIf([Actual Work]=0,0,[Actual Work]-[Baseline Work]),pjHours)

The "ProjDurConv" function Converts an expression to a duration value in the
specified units.

However it is better that you use the MS Project field "Work Variance". The
Work Variance field contains "0 hrs" until the work value varies from the
baseline work value, as shown in the Baseline Work field. Microsoft Office
Project 2003 then calculates work variance as follows:

Work Variance = Work - Baseline Work

Another important thing to note is that duration and work are two different
entities. MS Project also provides the duration variance field. The Duration
Variance field contains "0 days" until the duration value varies from the
baseline duration value, as shown in the Baseline Duration field. Microsoft
Office Project 2003 then calculates duration variance as follows:

Duration Variance = Duration - Baseline Duration

Kind regards,

--
Haris
http://www.manage-systems.com

I am using the following formula to get the variance of work to display in
one of our views.

I placed the formula in one of the duration1 field. The formula is

IIf([Actual Work]=0,0,[Actual Work]-[Baseline Work])

Everything works fine except I get the result in days instead of hours.
What do I need to do to get the correct units.

Thanks

Bill

I posted on the old http://support.microsoft.com/newsgroups/default.aspx Not
realizing that it is shutting down.

 

[Gérard Ducouret]

Bill,

Have you tried : Tools / Options / Schedule / Show duration as: days

Gérard Ducouret

Haris,

Thanks for the formula did know that existed. I have one more question....
Is there a reason why on the rollup the units convert back to days?

Thanks

Bill

hi Bill,

Here is how you can convert to hours in MS Project:

ProjDurConv(IIf([Actual Work]=0,0,[Actual Work]-[Baseline Work]),pjHours)

The "ProjDurConv" function Converts an expression to a duration value in the
specified units.

However it is better that you use the MS Project field "Work Variance". The
Work Variance field contains "0 hrs" until the work value varies from the
baseline work value, as shown in the Baseline Work field. Microsoft Office
Project 2003 then calculates work variance as follows:

Work Variance = Work - Baseline Work

Another important thing to note is that duration and work are two different
entities. MS Project also provides the duration variance field. The Duration
Variance field contains "0 days" until the duration value varies from the
baseline duration value, as shown in the Baseline Duration field. Microsoft
Office Project 2003 then calculates duration variance as follows:

Duration Variance = Duration - Baseline Duration

Kind regards,

--
Haris
http://www.manage-systems.com

I am using the following formula to get the variance of work to display in
one of our views.

I placed the formula in one of the duration1 field. The formula is

IIf([Actual Work]=0,0,[Actual Work]-[Baseline Work])

Everything works fine except I get the result in days instead of hours.
What do I need to do to get the correct units.

Thanks

Bill

I posted on the old http://support.microsoft.com/newsgroups/default.aspx Not
realizing that it is shutting down.