Duration Column Format

[aushardy]

Part 1 - I have a summary task that works out to be "20.86 wks". How can I
change the number format to reduce decimals so I can see "20.9 wks"?

Part 2 - when I entered the durations, I did so in days. Now it appears that
if all of it were shown in "wks" if would be better. How do i change the
format all the entries to be the same unit?

 

[Rod Gill]

Hi,

1) There isn't a utility to round Duration values I'm afraid.
2) Select Tools, Macros and select the Format Duration macro then click Run
Choose Weeks in the dialog that appears and you're done!

--

Rod Gill
Microsoft MVP for Project

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

 

[Dave]

Part 1 - I have a summary task that works out to be "20.86 wks". How can I
change the number format to reduce decimals so I can see "20.9 wks"?

If you add another column you can use a formula to round the duration
although I would wonder personally whether it was worth the effort.

The type of column you need depends partly on exactly what you want
displayed.

For example in a spare number field you could use the formula:

Fix( ( [duration] / 60 / <your hours per day setting> / 5 + 0.05 ) * 10
) / 10

This will round to 1 decimal place

If you want to add the "wks" then you will have to do additional
formatting with the text fields.

There may be more elegant methods.