none
Round Display of work-days to nearest whole day RRS feed

  • Question

  • How do I round the display of work-days to the nearest whole day in the task list?

    Thanks,

    Daniel

    Tuesday, April 3, 2012 2:33 PM

Answers

  • The screenshot below shows how you could conifgure a custom field to do this.

    1 - Right click on a column heading
    2 - From the right click menu choose Custom Fields
    3 - Edit the formula for Number1 as:
                   int(([Work]/60/7.5)+0.499999999)
    4 - Click OK
    5 - Double click on the newly inserted column and amend the title, e.g. to "Work (Rounded Days)" as shown in this example.


    Tuesday, April 3, 2012 3:14 PM

All replies

  • Hello Daniel,

    There is no Excel-like display format control mechanism in Project. Project stores the duration values in minutes. As an example, a duration value displayed as 1.75 days is stored as 840 minutes. You can use a custom field to display a rounded number, but just for display.

    Regards.

    Tuesday, April 3, 2012 2:49 PM
  • The screenshot below shows how you could conifgure a custom field to do this.

    1 - Right click on a column heading
    2 - From the right click menu choose Custom Fields
    3 - Edit the formula for Number1 as:
                   int(([Work]/60/7.5)+0.499999999)
    4 - Click OK
    5 - Double click on the newly inserted column and amend the title, e.g. to "Work (Rounded Days)" as shown in this example.


    Tuesday, April 3, 2012 3:14 PM