none
MS-Project 2010: New column with duration in months... RRS feed

  • Question

  • Hello together,

    I have a problem: My Schedule are defined in days (duration). This is ok, but I want for me a 2nd column with the duration calculated in months. Is it possible?

    THX,

    Tobias

    Thursday, July 21, 2011 12:38 PM

Answers

  • Tobias --

    Hmm, it seems Microsoft Project 2010 wants to format EVERY Duration column using Days, even custom Duration columns.  Well, let's approach this problem in a different way.  Create a custom task Text field and include the following formula for the field:

    Format([Duration]/(20*60*8),"#,##0.00") & " months"

    The above formula assumes an 8-hour working day and 20 working days in a month.  The Format function will round the resulting Duration to 2 decimal points.  The last part of the formula appends the word "months" at the end of the resulting Duration value.  Hope this helps.


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    • Marked as answer by der_toby Friday, July 22, 2011 8:18 AM
    Thursday, July 21, 2011 4:28 PM
    Moderator

All replies

  • Tobias --

    There is no automatic way to handle this situation.  If you are willing, you would need to create a custom task Duration field (column) containing a formula to convert the Duration value to months.  Your only problem is what constitutes a "month" in your way of thinking?  Is a month 20 working days, or 21 working days, or 22 working days, for example?  Based on how you answer that question, you could use a formula similar to the one I show below where I assume a "month" is 20 working days:

    [Duration]/20

    Hope this helps.


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Thursday, July 21, 2011 12:51 PM
    Moderator
  • Hello Dale,

    thx for that. That is also what I tried before, the problem is than (when I take e.g. Duration 1), that I get the number of months but with the name days in the end.

    For example: Duration = 40 days, than I insert Duration 1 with the formula and I get: 2 days.

    Bye,

    Tobias

    Thursday, July 21, 2011 3:48 PM
  • Tobias --

    Hmm, it seems Microsoft Project 2010 wants to format EVERY Duration column using Days, even custom Duration columns.  Well, let's approach this problem in a different way.  Create a custom task Text field and include the following formula for the field:

    Format([Duration]/(20*60*8),"#,##0.00") & " months"

    The above formula assumes an 8-hour working day and 20 working days in a month.  The Format function will round the resulting Duration to 2 decimal points.  The last part of the formula appends the word "months" at the end of the resulting Duration value.  Hope this helps.


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    • Marked as answer by der_toby Friday, July 22, 2011 8:18 AM
    Thursday, July 21, 2011 4:28 PM
    Moderator
  • Hi,

    Just for the sake of completeness, it is more general to replace 8*60 by [Minutes per Day]

    Greetings,

    Thursday, July 21, 2011 5:18 PM
    Moderator
  • If I am not mistaken ProjDurConv([Duration], pjMonths) works as well but we cannot control "Days per month" in the formula.


    Regards. --Ismet
    Thursday, July 21, 2011 7:03 PM
  • Jan --

    A nice tweak to the original formula.  Thanks for sharing!  :)


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Thursday, July 21, 2011 8:27 PM
    Moderator
  • Ismet --

    A nice alternative to my original formula.  Thanks for sharing!  :)


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Thursday, July 21, 2011 8:28 PM
    Moderator
  • Thank you - that work fine!
    Friday, July 22, 2011 8:18 AM
  • Hi Dale,

    Thanks for the tips.  This approach works, however it only seems to work at the task level and not the task rollout or summary level rows.  Any tips or am I overlooking an easy fix?

    Thanks for your help.

    Wednesday, August 24, 2011 9:02 PM
  • jrmicrosoft --

    Yes, you are missing something obvious.  In the "Calculation for task and group summary rows" section of the Custom Fields dialog, you have to select the "Use formula" option.  Hope this helps.


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Wednesday, August 24, 2011 11:24 PM
    Moderator
  • ah, perfect.  thanks!
    Thursday, August 25, 2011 6:47 PM
  • jrmicrosoft --

    You are more than welcome for the help, my friend!  :)


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Friday, August 26, 2011 1:30 AM
    Moderator