Skip to content

14.8 weeks - i want it to say 15 weeks

Emma TrescottMember for 7 years 4 months
Created
3
3
0

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

3 replies

Oldest first
  1. 0
    Tom Boyle ·

    Hi 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.

  2. 0
    Alexandre Faulx-Briole ·

    Hi 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

     

  3. 0
    Rafael Davila ·

    I 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

    Change-MSP-Calendar-Options

    Hope this can give you a clue.

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?