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.
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;
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
Member for
21 years 8 monthsI do not have MSP but used it
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
Hope this can give you a clue.
Member for
22 years 9 monthsHi Emma,Duration fields in MS
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 monthsHi Emma,Please revise the
Hi Emma,
Please revise the question and try to be clear. You've implied about 3 or 4 competing issues here.