none
Show Summary Tasks in elapsed time

    Frage

  • Hi

    I have set up a high level programme using "emonths" for all the tasks.

    However, the duration of the summary tasks is in working time "months".

    Spent a good while trying to change the summary tasks to "emonths" to no avail.

    Can anyone help?

    Many thanks

    Mark 

    Freitag, 25. Januar 2013 07:24

Antworten

  • Mark --
     
    To the best of my knowledge, there is no way to force Microsoft Project to display summary task Duration values in elapsed time.  If you want to show the Durations of summary tasks in elapsed months, the best you might be able to do is to create a custom enterprise field containing a formula to calculate Durations using elapsed time (if that is even possible).  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"

    • Als Antwort markiert Mark Limerick Donnerstag, 31. Januar 2013 01:28
    Freitag, 25. Januar 2013 15:53
    Moderator

Alle Antworten

  • Mark --
     
    To the best of my knowledge, there is no way to force Microsoft Project to display summary task Duration values in elapsed time.  If you want to show the Durations of summary tasks in elapsed months, the best you might be able to do is to create a custom enterprise field containing a formula to calculate Durations using elapsed time (if that is even possible).  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"

    • Als Antwort markiert Mark Limerick Donnerstag, 31. Januar 2013 01:28
    Freitag, 25. Januar 2013 15:53
    Moderator
  • Thanks for taking the time to reply Dale - much appreciated

     
    Donnerstag, 31. Januar 2013 01:29
  • Mark --
     
    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"

    Donnerstag, 31. Januar 2013 08:22
    Moderator
  • Dale said: If you want to show the Durations of summary tasks in elapsed months, the best you might be able to do is to create a custom enterprise field containing a formula to calculate Durations using elapsed time (if that is even possible). 

    I created a Custom Field to show elapsed days of Tasks and Summary Tasks. Using a Number field, the formula I used is:

    DateValue([Finish])-DateValue([Start])

    This will calculate based on date only, ignoring partial days based on working hours. I labeled it Elapsed Days. You could add the math to convert days into months, on whichever basis you choose (28 or 30 days per month).

    Then in the Custom Fields window, under "Calculation for task and group summary rows", I selected "Use formula".

    So for example, a Summary Task with a Start of 4/10 and a Finish of 4/29 will show Elapsed Days of 19.

    I realize this question was posted 4 years ago, but since I found it while searching for confirmation that this was the way to go, the least I could do was add to it with my solution. Hope this helps the next person!

    -Sharon

    Sharon Fry
    Software Specialist & Microsoft Certified Trainer
    www.sharonfry.com
    MOS Master, MCT, MCP, MTA


    • Bearbeitet SharonFryLV Mittwoch, 5. April 2017 21:22 formatting of code
    Mittwoch, 5. April 2017 21:21
  • Why not just make a 7 days/week calendar and assign that calendar to the summary? The duration of the summary will be in working days as measured by the calendar assigned to it.
    Freitag, 7. April 2017 20:42
  • Hello Sharon,

    Thank you for this very useful tip.  I searched a lot and could not find anything except for your post.  I use Durations for Working Days, which excludes weekends and holidays.  This works well, as intended, but it confuses non-project lay-people because Duration days, weeks, and months do not arithmetically add up to an aggregated total elapsed calendar period. 

    So, a 720-day Working Duration (work days only) is actually 1003-days elapsed duration (includes weekends and holidays specific to this company).  Thanks to your formula, I can express this in the added custom field so that the difference in time is better understood by all.  

    Warm regards, cliff

    tulsultant@yahoo.com


    Cliff

    Donnerstag, 7. Juni 2018 11:55