Duration Field export to access mdb

[Steve Scott]

I need to run a query in an Access mdb which lists tasks across multiple
projects that have durations >10 days within the next month. Exporting from
MS Project to Access will only do so in a numerical format eg "4200" for 1 x
7 hr day.

How can I convert these values into days easily ie as they were displayed in
the original plans bearing in mind that some of the plans had 7hr working
days and others 8hr working days?

Alternatively is there a way I can run the export map and get the displayed
value (ie in days) to be exported instead of the eg 4200 format?

 

[Jim Aksel]

You will need to do the conversion in Access using a formula applied to a new
field.
Unfortunately, you will also have to include the logic to decide which of
these tasks were based on 8 hour or 7 hour days.

The value you are being presented is in minutes ... this is how MS Project
stores the value.
--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[Steve Scott]

thanks..is there any field that can be added to my export map that shows the
configuration setting of hrs per day?

 

[JulieS]

Hello Steve,

Pardon me for bumping in. There is not a direct task field that shows
the information but there is a Project field named [Minutes per day]
which contains the number of minutes defined as a "day". You could add
a custom number field in a task view and then set the formula for the
field to [Minutes per day]. Set the summary tasks to use the formula.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[Steve Scott]

Thanks to both of you for your help

Steve

Hello Steve,

Pardon me for bumping in. There is not a direct task field that shows
the information but there is a Project field named [Minutes per day]
which contains the number of minutes defined as a "day". You could add
a custom number field in a task view and then set the formula for the
field to [Minutes per day]. Set the summary tasks to use the formula.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

thanks..is there any field that can be added to my export map that
shows the
configuration setting of hrs per day?

 

[Steve Scott]

Thanks to both of you for your help

Steve

You will need to do the conversion in Access using a formula applied to a new
field.
Unfortunately, you will also have to include the logic to decide which of
these tasks were based on 8 hour or 7 hour days.

The value you are being presented is in minutes ... this is how MS Project
stores the value.
--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[JulieS]

You're welcome Steve and thanks for the feedback.

Julie

Thanks to both of you for your help

Steve

Hello Steve,

Pardon me for bumping in. There is not a direct task field that
shows
the information but there is a Project field named [Minutes per day]
which contains the number of minutes defined as a "day". You could
add
a custom number field in a task view and then set the formula for the
field to [Minutes per day]. Set the summary tasks to use the
formula.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project

thanks..is there any field that can be added to my export map that
shows the
configuration setting of hrs per day?

:

You will need to do the conversion in Access using a formula
applied
to a new
field.
Unfortunately, you will also have to include the logic to decide
which of
these tasks were based on 8 hour or 7 hour days.

The value you are being presented is in minutes ... this is how MS
Project
stores the value.
--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project



:

I need to run a query in an Access mdb which lists tasks across
multiple
projects that have durations >10 days within the next month.
Exporting from
MS Project to Access will only do so in a numerical format eg
"4200" for 1 x
7 hr day.

How can I convert these values into days easily ie as they were
displayed in
the original plans bearing in mind that some of the plans had
7hr
working
days and others 8hr working days?

Alternatively is there a way I can run the export map and get
the
displayed
value (ie in days) to be exported instead of the eg 4200 format?