Question using formula in Project professional

[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

 

[Dale Howard [MVP]]

Bill --

When you placed the formula in a custom Duration field, the result is
formatted in days because the default measure of Duration is days. Instead,
place the formula in a custom Number field, but divide the result by 60, as
Work is stored in minutes in the Project Server database. Hope this helps.

 

[Mike Glen]

Hi Bill,

Try posting on the server newsgroup as this one's closing down. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP