Duration problem , when adding tasks to an existing project by vba

[fkartal]

Hi all,

I have an ERP db on SQL 2K it has some tables about project and its tasks.
When creating new Ms Project and adding its tasks duration couldnot be
exported correctly.
As a simple Im assigning
Start Date,
Duration, Precedence and Finish Date to the new task. At the end the
duration calculated as almost zero day but really it would be 10 day.

Thanks for any comment

 

[Jan De Messemaeker]

Hi,

Why are you exporting start date, finish date AND duration?
That is one too many since duration is the (calendar) time between start and
finish.
I suggest you only export start and duration, and if the task is really
determined by dependencies only dependencies and duration.

Project is a calculation tool not just a drawing tool.

HTH

 

[Rod Gill]

Duration is stored as a number of minutes, so 1d is usually 1*8*60 minutes.

Jan's correct in saying don't import start, finish and duration.. If you
have a predecessor then only import predecessor and duration, otherwise
Start and duration.

 

[fkartal]

Thanks Jan and Rod for your valuable comments.

 

[doniy]

If I want to convert a duration from minutes to day, shall I consider the
calendar.
if the task calendar is 7hrs/day, then 1day is 1*7*60 minutes, is it right?

 

[Rod Gill]

No,

Calendar ONLY used to calculate when the duration number of minutes can be
completed. So calendar affects finish date but never duration.

 

[Jan De Messemaeker]

Hi,

Attention. The conversion factor "Hours per day" is not derived from ANY
calendar but can be found in Tools, Options, Calendar. THAT figure is to be
multiplied by 60 to get minutes per day.
HTH

 

[doniy]

thanks

Hi,

Attention. The conversion factor "Hours per day" is not derived from ANY
calendar but can be found in Tools, Options, Calendar. THAT figure is to be
multiplied by 60 to get minutes per day.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

 

[doniy]

thanks

No,

Calendar ONLY used to calculate when the duration number of minutes can be
completed. So calendar affects finish date but never duration.