Remove "days" from duration field(s)

[mcbrilt]

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.

 

[salgud]

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?

 

[Gérard Ducouret]

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]

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.

 

[Gérard Ducouret]

Maybe the VBA procedure written by Jack Dahlgren could be useful for you:
http://masamiki.com/docs/trace-task-dependencies.html

Gérard Ducouret