Adding duration days onto dates

[Robert]

Hi all,

I have created a custom duration1. Duration1 is 25% of
duration. Duration2=125%

Example:

Duration= 10 days
Duration1=Duration/4 = 2,5 days
Duration2=Duration+(Duration/4)=12,5 days

I have a startdate 1st May 2006, Finish 12th May 2006
(i.e. 10 days including a weekend)

What I like to do is add those 2,5 days onto finish date
(or 12,5 days onto the start date) showing up on the Gantt
bar chart aswell.

Adding duration2 (12,5 days) onto start date (logical
enough) gives me a finish1 date of 04-10-2022 *lol*
Adding Duration1 (2,5 days) onto finish date gives finish2
date of 15-10-2022

Any ideas, hints or tips there???
Thanks in advance
Robert

 

[Jan De Messemaeker]

Hi Robert,

Duration is calculated in minutes.
You seem to add them as days
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[robert]

if this was the case 2,5 days is 3600 minutes, which you
say I might be adding as days.. thats 9,89 years...
2022.... Hmm... Afraid the maths doesnt fit, but even if
its something like that which is giving the problem how
do I then add days onto a task????

R

 

[Jan De Messemaeker]

Hi again,

With formulas I wouldn't know becaus the fields we are talking about
(duration, start, finish) aren't custoime fields so they do not accept a
fomula.
Are you talking VBA then?
Or do you want to calculate a pseudo-finish in a fee field?
On both I can help.
Greetings

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[Robert]

Greetings

Looking at the problem from another angle, one would say
that I wish to create a pessimistic gantt which reflects
my normal gantt plus(0-100)% This percentage should be in
days so that if a task takes an expected 10 days, the pess
chart would show a pess duration of 11 days (10 days plus
a pess value of 10%)and optimistic of 9 days.

This would have been enough, but now that I have run into
the other problem of adding days onto a task, it is almost
a quest now to get that figured out.

I have a solid startdate, & duration. Finish date, & work
already worked out. I now think.. hmmm.. that duration
needs an additional(10% or days). Great.. I create Custom
Duration Field1 with [duration]*1.1 formula and then comes
the crusher!!! A new Custom Finish Field that adds
duration1 onto the start date...

kind regards
R

 

[Steve House]

I think you're not understanding the role of MS Project fully, the tip off
is you

Greetings

Looking at the problem from another angle, one would say
that I wish to create a pessimistic gantt which reflects
my normal gantt plus(0-100)% This percentage should be in
days so that if a task takes an expected 10 days, the pess
chart would show a pess duration of 11 days (10 days plus
a pess value of 10%)and optimistic of 9 days.

This would have been enough, but now that I have run into
the other problem of adding days onto a task, it is almost
a quest now to get that figured out.

I have a solid startdate, & duration. Finish date, & work
already worked out. I now think.. hmmm.. that duration
needs an additional(10% or days). Great.. I create Custom
Duration Field1 with [duration]*1.1 formula and then comes
the crusher!!! A new Custom Finish Field that adds
duration1 onto the start date...

kind regards
R

-----Original Message-----
Hi again,

With formulas I wouldn't know becaus the fields we are talking about
(duration, start, finish) aren't custoime fields so they do not accept a
fomula.
Are you talking VBA then?
Or do you want to calculate a pseudo-finish in a fee field?
On both I can help.
Greetings

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620



.

 

[Steve House]

It seems you may not be fully understanding the best way to use MS Project,
the tipoff to that being your phrasing "worked out start date, duration,
work, finish date." In the best of all possible worlds you work out just
the main start date of the project, the estimated durations of the tasks,
and the logical relationships, ie links, between the tasks, and Project
calculates all the other start and finish dates for you. When you assign
the resources, Project uses those same durations to calculate the work each
task will require. Your contingencies are dialed in to the durations and
using PERT you can say it's probably going to take us 3 weeks to build the
widgets with a 66% probability we can do it within +- 3 days and a 90%
probability we can do it +- 6 days etc.

Greetings

Looking at the problem from another angle, one would say
that I wish to create a pessimistic gantt which reflects
my normal gantt plus(0-100)% This percentage should be in
days so that if a task takes an expected 10 days, the pess
chart would show a pess duration of 11 days (10 days plus
a pess value of 10%)and optimistic of 9 days.

This would have been enough, but now that I have run into
the other problem of adding days onto a task, it is almost
a quest now to get that figured out.

I have a solid startdate, & duration. Finish date, & work
already worked out. I now think.. hmmm.. that duration
needs an additional(10% or days). Great.. I create Custom
Duration Field1 with [duration]*1.1 formula and then comes
the crusher!!! A new Custom Finish Field that adds
duration1 onto the start date...

kind regards
R

-----Original Message-----
Hi again,

With formulas I wouldn't know becaus the fields we are talking about
(duration, start, finish) aren't custoime fields so they do not accept a
fomula.
Are you talking VBA then?
Or do you want to calculate a pseudo-finish in a fee field?
On both I can help.
Greetings

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620



.

 

[robert]

Ahh,

But Im afraid that I dont live in a world where everything
is just black or white and nothing in between, my friend.

As my MS Project teacher once said "Everything is possible
in MS Project, the only thing you need is imagination and
the knowledge to carry it out."

This task that I am tring to achieve is something that I
have been asked to do. How its done is irrelivent, just as
long as it shows the desired view.

As far as the tipoff... please note the fullstop in between

"I have a solid startdate, & duration." and
"Finish date, & work already worked out."

Regards
Robert

 

[Jan De Messemaeker]

Hi Robert,

If you want to set a formula to calculate a start date in a custom field,
use the ProjDateAdd function and mingd that it expects a duration in
minutes.

If you want to put a value of your own in *THE* start field of the task,
that is not possible with a formula, you will need a VBA procedure.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[Steve House]

Sorry, both messages were sent prematurely - cat batting the keyboard
touchpad

Greetings

Looking at the problem from another angle, one would say
that I wish to create a pessimistic gantt which reflects
my normal gantt plus(0-100)% This percentage should be in
days so that if a task takes an expected 10 days, the pess
chart would show a pess duration of 11 days (10 days plus
a pess value of 10%)and optimistic of 9 days.

This would have been enough, but now that I have run into
the other problem of adding days onto a task, it is almost
a quest now to get that figured out.

I have a solid startdate, & duration. Finish date, & work
already worked out. I now think.. hmmm.. that duration
needs an additional(10% or days). Great.. I create Custom
Duration Field1 with [duration]*1.1 formula and then comes
the crusher!!! A new Custom Finish Field that adds
duration1 onto the start date...

kind regards
R

-----Original Message-----
Hi again,

With formulas I wouldn't know becaus the fields we are talking about
(duration, start, finish) aren't custoime fields so they do not accept a
fomula.
Are you talking VBA then?
Or do you want to calculate a pseudo-finish in a fee field?
On both I can help.
Greetings

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620



.

 

[bill]

How do you write the ProjDateAdd function?

-----Original Message-----
Hi Robert,

If you want to set a formula to calculate a start date in a custom field,
use the ProjDateAdd function and mingd that it expects a duration in
minutes.

If you want to put a value of your own in *THE* start field of the task,
that is not possible with a formula, you will need a VBA procedure.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620



.