Forum Discussion
Solved
ROUND Function Not Work To Round Duration Custom Fields
I am trying to round custom duration fields to whole numbers using the ROUND function as ROUND([Actual Work]), however the field is displaying the field with decimals still. The function does seem t...
- JBLT83 --
In Microsoft Project, you have to use the Format function to display calculated values at the precision you desire. The Format function works in a similar manner to its counterpart in Microsoft Excel. Following is how you might want to write the formula:
Format(Round([Actual Work]/60),"#,##0")
By the way, if you are using a Number field for your formula, you need to divide the Actual Work value by 60. This is because Microsoft Project tracks Work fields at the 1-minute level, so to display the resulting value in Hours, you must divide by 60. Hope this helps.
JBLT83 --
In Microsoft Project, you have to use the Format function to display calculated values at the precision you desire. The Format function works in a similar manner to its counterpart in Microsoft Excel. Following is how you might want to write the formula:
Format(Round([Actual Work]/60),"#,##0")
By the way, if you are using a Number field for your formula, you need to divide the Actual Work value by 60. This is because Microsoft Project tracks Work fields at the 1-minute level, so to display the resulting value in Hours, you must divide by 60. Hope this helps.
In Microsoft Project, you have to use the Format function to display calculated values at the precision you desire. The Format function works in a similar manner to its counterpart in Microsoft Excel. Following is how you might want to write the formula:
Format(Round([Actual Work]/60),"#,##0")
By the way, if you are using a Number field for your formula, you need to divide the Actual Work value by 60. This is because Microsoft Project tracks Work fields at the 1-minute level, so to display the resulting value in Hours, you must divide by 60. Hope this helps.
Dale_HowardMVP Thanks for the quick response. Actually, I was using a custom duration field containing the actual work field, and it actually took care of converting Actual Work hours into days, so I didn't have to include the /60.