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 to work if I use a Text Custom field type though. Why doesn't it work for a custom duration field?
- 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.
