Results 1 to 3 of 3

Thread: total duration column

  1. #1
    Join Date
    Nov 2005

    total duration column

    I have created multiple tasks in MS Project. In all these tasks what I want to do is sum all sub tasks and show the sum of the days at main task level. I tried doing the same but only managed to get the duration of the tasks not the total duration. My tasks are as follows:
    one task - 20-May-2010 to 25-May-2010 - 5 days
    two task - 21-May-2010 to 28-May-2010 - 6 days.

    I believe there is any field which I need to work on. Can anyone please tell me which one is it?

  2. #2
    Join Date
    Sep 2005

    Re: total duration column

    As far as I know about MS Project, it will calculate the duration of the summary task as the number of working days between 20th May through 28th May because according to the task details mentioned above it overlaps from 21-May through 25-May. Though there are 6 days from 20th to 25th May but Iíll count only 4 days as there is a Saturday and Sunday non working days. If you have resources assigned to the first task who has Saturday or Sunday as a working day, I would like to ask whether you want the sum of the work, not the sum of the durations?

    - You can have Project sum durations if you choose to given my comments above. Add an custom duration field (Duration1) and customize the field with the formula [duration]. Set the option for group or summary rows to sum.

    I hope this helps. Let us know how you get along.

  3. #3
    Join Date
    Jan 2006

    Re: total duration column

    Yes, you are correct. Assuming the default standard calendar, note that the duration of your first task is not 5 days but 4 - the 20th, 21st, 24th, and 25th. Since Sat and Sun the 22nd and 23rd are non-working days, they don't count in the duration.

Similar Threads

  1. How to move the total column in Microsoft Excel Pivot Table
    By (Cowherd) in forum MS Office Support
    Replies: 2
    Last Post: 15-02-2012, 04:55 PM
  2. Cash Flow Report Total Cost Does Not Match Gantt Total Cost?
    By kaorisdad in forum Microsoft Project
    Replies: 5
    Last Post: 26-08-2011, 06:50 AM
  3. Find The Value of one column in another column
    By Charth in forum Windows Software
    Replies: 3
    Last Post: 23-02-2011, 02:01 AM
  4. Replies: 3
    Last Post: 09-12-2009, 12:11 PM
  5. mysql update column with another column
    By Gunter in forum Software Development
    Replies: 3
    Last Post: 23-05-2009, 09:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts