Project 2007 - Rounding up Duration Values

[Luca]

HI,

Just wondering if it is possible to round up the 'remaining duration' values
to whole days rather than decimals? When I put in the % complete of work it
then changes the remaining duration accordingly but I'd like to set it so it
rounds all the numbers to the nearest whole duration.

Your help is greatly appreciated.

Luca

 

[Rod Gill]

Without writing a VBA macro you can't do this. However you could change your
update method to entering an Actual Start Date and then Actual Duration and
Remaining duration or Actual Work and Remaining work for each assignment if
you have two or more resources assigned. This will result in whole numbers
for you.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Dave]

HI,

Just wondering if it is possible to round up the 'remaining duration' values
to whole days rather than decimals? When I put in the % complete of work it
then changes the remaining duration accordingly but I'd like to set it so it
rounds all the numbers to the nearest whole duration.

Your help is greatly appreciated.

Luca

You could use a formula which rounded the duration value and placed it
in a spare duration field.