Remove decimal sign in Days

P

PE

How is it possible to hide or round up/down the numbers after the decimal sign in days eg. 12.5 days become 13 days, and 12,2 is 12 days?
 
J

John

PE,
I assume the fractional day values are appearing in the Duration field
instead of a customized field (e.g. Duration1). Depending on your
intent, one way to eliminate fractional days is to modify the schedule
so that all tasks start and finish at the beginning and end of normal
work days. This can either be done manually or through VBA code. However
this may neither be convenient nor desirable. The next suggestion is to
create a custom field that takes the Duration field and applies a
rounding function.

Hope this helps.
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top