Sum the days between two tasks
in [Project]
|
From: Brad Harris on 8 Sep 2009 17:06 MS Project 2007 Pro How do I sum the dyas between two tasks. Pick any two tasks on a splan and get the number of days between the start of the two?
From: JulieS on 8 Sep 2009 17:26 Hello Brad, Sorry, you cannot do math in project referencing different project tasks. You can calculate the difference between dates on a single task, (Start, Start1, etc) but not automatically between tasks. It may be possible through VBA, but perhaps if you describe why you need this we can suggest an alternative. I hope this helps. Let us know how you get along. Julie Project MVP Visit http://project.mvps.org/ for the FAQs and additional information about Microsoft Project "Brad Harris" <BradHarris(a)discussions.microsoft.com> wrote in message news:E80DD9C0-9B69-44A7-8991-0BDBF8BB4DA8(a)microsoft.com... > MS Project 2007 Pro > How do I sum the dyas between two tasks. Pick any two tasks on a > splan and > get the number of days between the start of the two?
From: Jim Aksel on 8 Sep 2009 17:33 You are going to need to use some VBA to get to the solution. You will need a combination of the functions ProjDateDiff(), ProjDateSub(), and ProjDurValue(). However, you are going to have to feed these functions the start (or finish) dates of the separate tasks in question. What are you trying to accomplish? Might it be easier to indent the two tasks under a summary task and then examine that duration? -- If this post was helpful, please consider rating it. Jim Aksel, MVP Check out my blog for more information: http://www.msprojectblog.com "Brad Harris" wrote: > MS Project 2007 Pro > How do I sum the dyas between two tasks. Pick any two tasks on a splan and > get the number of days between the start of the two?
From: Brad Harris on 8 Sep 2009 17:42 Thanks, The user wants to click on a task and click on another task and look at the relationship between the two in days. I was telling him we could probably setup a formula looking at the dates. What would the formula look like? Start1-Start2 how is it exactly? "Jim Aksel" wrote: > You are going to need to use some VBA to get to the solution. > You will need a combination of the functions ProjDateDiff(), ProjDateSub(), > and ProjDurValue(). > > However, you are going to have to feed these functions the start (or finish) > dates of the separate tasks in question. > > What are you trying to accomplish? Might it be easier to indent the two > tasks under a summary task and then examine that duration? > -- > If this post was helpful, please consider rating it. > > Jim Aksel, MVP > > Check out my blog for more information: > http://www.msprojectblog.com > > > > "Brad Harris" wrote: > > > MS Project 2007 Pro > > How do I sum the dyas between two tasks. Pick any two tasks on a splan and > > get the number of days between the start of the two?
From: JulieS on 8 Sep 2009 20:19 Brad, As I noted before, I don't believe you can make this happen through a simple formula . You'll have to capture the details on the "clicked" task through VBA, capture the details on the other "clicked" task and then through code determine the differences between the two values. You can calculate differences between dates on the _same_ task through functions such as ProjDateDiff() as Jim said but those relatively simple functions will not work to compare dates between different tasks. For help on the Project Functions, search help in MS Project on "Project functions". If you are interested in pursuing the possibilities through VBA and have some skill with VBA, I suggest posting your question including details such as -- what do you envision triggering the code, is displaying the information in a message box sufficient, and other details to the project developer newsgroup. Someone there can perhaps get you started in the correct direction with the code. Julie "Brad Harris" <BradHarris(a)discussions.microsoft.com> wrote in message news:AB1D143C-B31E-4CFB-8F25-3DA7AA954BAE(a)microsoft.com... > Thanks, > > The user wants to click on a task and click on another task and > look at the > relationship between the two in days. I was telling him we could > probably > setup a formula looking at the dates. What would the formula look > like? > Start1-Start2 how is it exactly? > > "Jim Aksel" wrote: > >> You are going to need to use some VBA to get to the solution. >> You will need a combination of the functions ProjDateDiff(), >> ProjDateSub(), >> and ProjDurValue(). >> >> However, you are going to have to feed these functions the start >> (or finish) >> dates of the separate tasks in question. >> >> What are you trying to accomplish? Might it be easier to indent >> the two >> tasks under a summary task and then examine that duration? >> -- >> If this post was helpful, please consider rating it. >> >> Jim Aksel, MVP >> >> Check out my blog for more information: >> http://www.msprojectblog.com >> >> >> >> "Brad Harris" wrote: >> >> > MS Project 2007 Pro >> > How do I sum the dyas between two tasks. Pick any two tasks on >> > a splan and >> > get the number of days between the start of the two?
|
Next
|
Last
Pages: 1 2 Prev: 596480 M3i Zero , Ezflash Dsi , R4i Dsi 83579 Next: Actual work and timesheet problem |