How do I remove days from the duration fields during export to Excel? I am trying to calculate my critical path duration PLUS the standard deviation on the critical path using PERT values.
On Wed, 8 Oct 2008 11:43:14 -0700, mcbrilt wrote: > How do I remove days from the duration fields during export to Excel? I am > trying to calculate my critical path duration PLUS the standard deviation on > the critical path using PERT values. Why are you doing it in XL? Why not in Project?
Hello, I think you can calcultae your own "duration" field: Insert a Number(x) field, Tools / Customize / Fields... In the Custom fields dialog, click the formula button and copy (or enter) this simple formula: [Duration]/[Minutes Per Day] That's this custom field that you will export to Excel Hope this helps, Gérard Ducouret "mcbrilt" a écrit dans le message de news: 0C49A317-B122-4375-A43F-9B7A72786352@microsoft.com... > How do I remove days from the duration fields during export to Excel? I am > trying to calculate my critical path duration PLUS the standard deviation > on > the critical path using PERT values.
My most critical milestone is not at the end of my schedule. Also, there are items between the start of my project and the most critical milestone that will drive the critical path out. I want to export critical tasks and durations to excel, and calculate my own critical path after I remove the other tasks I mentioned above. "salgud" wrote: > On Wed, 8 Oct 2008 11:43:14 -0700, mcbrilt wrote: > > > How do I remove days from the duration fields during export to Excel? I am > > trying to calculate my critical path duration PLUS the standard deviation on > > the critical path using PERT values. > > Why are you doing it in XL? Why not in Project? >
Maybe the VBA procedure written by Jack Dahlgren could be useful for you: http://masamiki.com/docs/trace-task-dependencies.html Gérard Ducouret "mcbrilt" a écrit dans le message de news: 26050EDF-3D14-4530-B9AD-942E3C93C0F4@microsoft.com... > My most critical milestone is not at the end of my schedule. Also, there > are > items between the start of my project and the most critical milestone that > will drive the critical path out. I want to export critical tasks and > durations to excel, and calculate my own critical path after I remove the > other tasks I mentioned above. > > "salgud" wrote: > >> On Wed, 8 Oct 2008 11:43:14 -0700, mcbrilt wrote: >> >> > How do I remove days from the duration fields during export to Excel? I >> > am >> > trying to calculate my critical path duration PLUS the standard >> > deviation on >> > the critical path using PERT values. >> >> Why are you doing it in XL? Why not in Project? >>
