Home Forums Discussion Microsoft Project formula for converting durations to work periods

This topic contains 3 replies, has 3 voices, and was last updated by  Thomas Hadley 8 months, 4 weeks ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #41162 Reply

    Angelo Arcoleo

    I’m trying to refine a Microsoft Project formula for converting durations to work periods.  I’ve come up with a specific formula but I want to generalize it regardless of which task calendar is applied.  Here’s what I’ve come up with so far….
     
    IIf([Task Calendar]=” 5d 8h Standard”,Duration/480,Duration*(8/12)/480)
     
    Here the 12 denominator is based on the fact that I’m using a 5d 12h calendar in addition to the 5d 8h Project Calendar.  So I want to generalize the formula to convert Duration to Work Periods using a Number field.
     

    Task Calendar

    Work Periods

    DUR

    TS-cd (Total Slack in calendar days)

    Name

    TS

    %

    Start

    Finish

    5d 12h Standard

    13.33

    20 d

    43.08

    Task 1

    31.25 d

    0%

    1/1/13

    1/28/13

    5d 8h Standard

    20

    20 d

    42

    Task 2

    30 d

    0%

    1/2/13

    1/29/13

     
    You’ll note that similarly, the formula for TScd above is: ([Late Finish]-[Scheduled Finish]).  That allows me to see “equivalent TS” regardless of which calendar is used. 

    Therefore, what formaula will generally apply to convert duration to work periods?

    #411439 Reply

    Ismet Kocaman

    Hi Angelo,

    How have you solved this issue ?

    Regards,
    Ismet

    #411515 Reply

    jean ghosh
    Member

    The users of this era completely advanced and always prefer hi-tech product and services. Microsoft is such kind of brand which is a leader in the current scenario from the past many decades. It has more than 300 products in its pockets for the users. If the users have any kind of technical hiccups then they can have help from Microsoft office phone number +1-877-833-8252 where they will be assisted by our well qualified and professional engineers with a quick response

    #411529 Reply

    I am in Australia another country outside of the USA 16 hrs time zone diff, what is the local phone number here please. I do not wish to make an international call

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Microsoft Project formula for converting durations to work periods
Your information:




61 + = 68