Creating a new bar from scratch

[Andrew]

I am trying to create a bar to represent planned progress ie how much of the
duration should have been done to the status date. I have the planned % via a
macro as a number and I thought I could get the planned duration by
pln%/100xbaseline duration and drop the days into a duration1 field - seems
to work. the problem I have is when I try to creat a finish to put it in the
bar format section via baseline start + Duration1 dropping it into Finish1
the date is out by literally years. What am I doing wrong?

Andrew

 

[John]

I am trying to create a bar to represent planned progress ie how much of the
duration should have been done to the status date. I have the planned % via a
macro as a number and I thought I could get the planned duration by
pln%/100xbaseline duration and drop the days into a duration1 field - seems
to work. the problem I have is when I try to creat a finish to put it in the
bar format section via baseline start + Duration1 dropping it into Finish1
the date is out by literally years. What am I doing wrong?

Andrew

Andrew,
Without knowing the details of your process here are a couple of hints
that may help.

First of all be aware that Project stores all time based data in tenths
of minutes. Therefore, even though you may see your duration displayed
as days, internally it is stored in minutes.

Second, how are you creating a date from a duration? You should be using
one of the date difference functions. I don't have Project open at the
moment so I can't give you the exact syntax but there are two functions.
One gives the difference in working time, (based on the Project's
working time calendar), and the other gives the difference in calendar
time.

Hope this helps.

John
Project MVP

 

[Andrew]

John

Great the date diff worked Thankyou very much

Andrew

 

[John]

John

Great the date diff worked Thankyou very much

Andrew

Andrew,
You're welcome and thanks for the feedback.

John
Project MVP