Rounding in Project 2000

[Phuong Nguyen]

I have a question regarding rounding. I am using a text field
as a duration field and would like to round the result to two decimal
points. The formula that I am using (without the rounding function) is
as follow TRIM([Duration2]*[Number5]/360)+' days'. The problem with
this formula is that it gives me more precision than needed.

Thanks,
Phuong

 

[John]

I have a question regarding rounding. I am using a text field
as a duration field and would like to round the result to two decimal
points. The formula that I am using (without the rounding function) is
as follow TRIM([Duration2]*[Number5]/360)+' days'. The problem with
this formula is that it gives me more precision than needed.

Thanks,
Phuong

Phuong,
If you want two decimal places, try the following formula:
format(cstr([Duration2]*[Number5]/480),"#.00")+" days"

Normally the divisor should be 480 which represents the standard 8 hour
word day. However, if your standard workday is 6 hours, then 360 is
correct.

Hope this helps.
John
Project MVP

 

[Phuong Nguyen]

Thanks John! It's exactly what I need.

Phuong

I have a question regarding rounding. I am using a text field
as a duration field and would like to round the result to two decimal
points. The formula that I am using (without the rounding function) is
as follow TRIM([Duration2]*[Number5]/360)+' days'. The problem with
this formula is that it gives me more precision than needed.

Thanks,
Phuong

Phuong,
If you want two decimal places, try the following formula:
format(cstr([Duration2]*[Number5]/480),"#.00")+" days"

Normally the divisor should be 480 which represents the standard 8 hour
word day. However, if your standard workday is 6 hours, then 360 is
correct.

Hope this helps.
John
Project MVP

 

[John]

Thanks John! It's exactly what I need.

Phuong

Phuong,
You're welcome.

John