Extracting duration from reporting database

[SharkTracker]

Generally when i use total slack in divide it by 8 which results in days. The
problem I run into is when total slack oe even duration is in elasped days.

How can I tell if duration or total slack is in elasped days so I can divide
it by 24?

 

[John]

Generally when i use total slack in divide it by 8 which results in days. The
problem I run into is when total slack oe even duration is in elasped days.

How can I tell if duration or total slack is in elasped days so I can divide
it by 24?

SharkTracker,
I'm not familiar with the "reporting database", (maybe it's Project
Server nomenclature), but Project stores all time related data (e.g.
duration, slack, etc.) in minutes. Therefore to extract duration data
from the database, the user would need to divide by 480 to convert to
days, assuming the default 8 hour day. If you are in fact able to divide
by 8 to convert hours of duration to days then that tells me the
reporting database data is in "display" format so it should be a simple
matter of checking the string for the presence of "e" or "ed" to
determine if the data is working time or elapsed time.

On the other hand if the data is in minutes your best bet is to find the
time difference between the start and finish. By inference you will be
able to tell if it is working time or elapsed time.

Hope this helps.

John
Project MVP

 

[Rod Gill]

Looking in the SDK I don't think there is a flag that says elapsed duration
(slack doesn't have elapsed). So, the only way is to calculate the number of
days between start and finish dates and if the difference is the same as the
duration (or nearly) then the duration is elapsed.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Generally when i use total slack in divide it by 8 which results in days.
The
problem I run into is when total slack oe even duration is in elasped
days.

How can I tell if duration or total slack is in elasped days so I can
divide
it by 24?

--
Sharktracker

__________ Information from ESET Smart Security, version of virus
signature database 4864 (20100213) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4865 (20100214) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[John]

Looking in the SDK I don't think there is a flag that says elapsed duration
(slack doesn't have elapsed). So, the only way is to calculate the number of
days between start and finish dates and if the difference is the same as the
duration (or nearly) then the duration is elapsed.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Rod,
I didn't think the Total Slack field showed elapsed time either but when
I did a little test file with Project 2007, I found that if duration is
in elapsed time then total slack will be also. Don't know if that's true
for other version though.

John
Project MVP

 

[Rod Gill]

Eugh! Oh well, you would need to compare difference between finish and late
finish to see if the Slack is elapsed or not.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Rod,
I didn't think the Total Slack field showed elapsed time either but when
I did a little test file with Project 2007, I found that if duration is
in elapsed time then total slack will be also. Don't know if that's true
for other version though.

John
Project MVP

__________ Information from ESET Smart Security, version of virus
signature database 4869 (20100215) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4869 (20100215) __________

The message was checked by ESET Smart Security.

http://www.eset.com