Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



total duration column

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 19-05-2010
Member
 
Join Date: Nov 2005
Posts: 38
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?

Reply With Quote
  #2  
Old 19-05-2010
Member
 
Join Date: Sep 2005
Posts: 227
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.
Reply With Quote
  #3  
Old 20-05-2010
Member
 
Join Date: Jan 2006
Posts: 7,144
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "total duration column"
Thread Thread Starter Forum Replies Last Post
How to move the total column in Microsoft Excel Pivot Table (Cowherd) MS Office Support 2 15-02-2012 04:55 PM
Cash Flow Report Total Cost Does Not Match Gantt Total Cost? kaorisdad Microsoft Project 5 26-08-2011 06:50 AM
Find The Value of one column in another column Charth Windows Software 3 23-02-2011 02:01 AM
How to highlight identical cell value of one column in another column? D_chapple Windows Software 3 09-12-2009 12:11 PM
mysql update column with another column Gunter Software Development 3 23-05-2009 09:44 AM


All times are GMT +5.5. The time now is 01:06 PM.