14.8 weeks - i want it to say 15 weeks

Member for

21 years 8 months

I do not have MSP but used it before.  Similar to other software I expect task hours/day be a function of the task calendar instead of the main calendar,  this relationship can be further complicated with calendar exceptions, not sure if this is captured in the proposed formula.  As I do not have MSP this you have to figure it out yourself. 

To make changes to the calendar "Week starts on:" see (click) the following link.

https://www.siliconbeachtraining.co.uk/blog/change-calendar-microsoft-project-2010

Change-MSP-Calendar-Options

Hope this can give you a clue.

Member for

22 years 9 months

Hi Emma,

Duration fields in MS Project are decimal fields with 2 decimal places; MSP automatically displays the necessary decimal place according to the value to be displayed;

i.e.: 8 hours = 1 day; 44 hours = 5.5 days; 46 hours = 5.75 days 

To display duration as an integer, use a User Defined Field (Task, Number), and a formula such as the following:

IIf([Number2]>0;(IIf([Number1]/[Number2]-int([Number1]/[Number2])<0.25;int([Number1]/[Number2]);int([Number1]/[Number2])+1));0)*480

This formula was created to compute duration by dividing Work Amount by Equipment Output and round the result to the next superior integer if the decimal places are greater than 0.25 

I hope to be understanble!

Alexandre

 

Member for

18 years 11 months

Hi Emma,

Please revise the question and try to be clear.  You've implied about 3 or 4 competing issues here.