Hello :-)
How do i get the duration to show just whole numbers e.g. 15w not 14.8w
The project is Mon to Fri 9-5pm.
I need to show the completion date as a friday not a sunday but still have the week as a whole number.
I have Sat & Sun as none working days in the project calendar.
Some tasks it works and some it doesn't and i can't undersatand why.
Please help :-)
Thanks
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.
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
Hi Emma,
Please revise the question and try to be clear. You've implied about 3 or 4 competing issues here.