none
How to count total calendar days of a task RRS feed

  • Question

  • In Project 2010 I need to have a column with the total of the calendar days, witch are different than the Duration field.

    I have to share a project to a client but he gets confused because the Duration field displays values that are not equal to the total calendar days of that task. How do I put a custom field that calculates the total days of the calendar of that task?

    Thank you

    Sunday, November 25, 2012 8:59 PM

Answers

  • Zandreus,

    This question has been asked many times. All you need to do is to customize a field (e.g. Duration1) with the following formula. Note: this formula assumes a standard 8 hour day of 480 minutes and that the default duration measurement is in days.

    DateDiff("d",[Start],[Finish])*480+480

    Hope this helps.

    John

    • Marked as answer by Lanidrake Sunday, December 2, 2012 11:16 AM
    Monday, November 26, 2012 1:55 AM
  • Are you using a duration custom field (not a number field)?
    • Marked as answer by Lanidrake Sunday, December 2, 2012 11:16 AM
    Tuesday, November 27, 2012 4:23 AM
  • Hi,

    just set "Calculation of task and summery rows" to "Use formula".

    Regards
    Barbara

    • Marked as answer by Lanidrake Sunday, December 2, 2012 4:29 PM
    Sunday, December 2, 2012 11:56 AM
    Moderator

All replies

  • Zandreus,

    This question has been asked many times. All you need to do is to customize a field (e.g. Duration1) with the following formula. Note: this formula assumes a standard 8 hour day of 480 minutes and that the default duration measurement is in days.

    DateDiff("d",[Start],[Finish])*480+480

    Hope this helps.

    John

    • Marked as answer by Lanidrake Sunday, December 2, 2012 11:16 AM
    Monday, November 26, 2012 1:55 AM
  • Just in case you are using a calendar with other than 8 hours per day, you could use this form for the formula:
    DateDiff("d",[Start],[Finish])*[Minutes per day]+[Minutes per day].

    Graham

    Monday, November 26, 2012 4:28 AM
  • Zandreus,

    This question has been asked many times. All you need to do is to customize a field (e.g. Duration1) with the following formula. Note: this formula assumes a standard 8 hour day of 480 minutes and that the default duration measurement is in days.

    DateDiff("d",[Start],[Finish])*480+480

    Hope this helps.

    John

    Ok, many thanks for the answers!

    But I think that this formula returns the values in minutes! Can it return in days as well?

    Thanks

    Monday, November 26, 2012 9:39 PM
  • Zandreus,

    No, it's set up to return the value in days, that's why the result is divided by 480. What is your setting under File/Options/Schedule group/scheduling options for this project subgroup/"Duration is entered in"? And what is your setting for "hours per day"? If your settings for either or both are different from the default, (i.e. duration in days, and 8 hours/day), the adjustment factors will be different.

    John

    Tuesday, November 27, 2012 2:20 AM
  • Are you using a duration custom field (not a number field)?
    • Marked as answer by Lanidrake Sunday, December 2, 2012 11:16 AM
    Tuesday, November 27, 2012 4:23 AM
  • Are you using a duration custom field (not a number field)?

    This was the issue! Thank you!

    Now I see that the summary tasks are not affected by this formula. They return 0. Is there any way to count the real calendar days for summary tasks as well? 

    Sunday, December 2, 2012 11:18 AM
  • Hi,

    just set "Calculation of task and summery rows" to "Use formula".

    Regards
    Barbara

    • Marked as answer by Lanidrake Sunday, December 2, 2012 4:29 PM
    Sunday, December 2, 2012 11:56 AM
    Moderator
  • Hi,

    just set "Calculation of task and summery rows" to "Use formula".

    Regards
    Barbara

    That worked fine! Thank you Barbara!
    Sunday, December 2, 2012 4:30 PM