Resource work shown in the MSP_Resources table of the *.MPD

S

Stretch

I am trying to translate the value of work found in the MSP_Resources table
of the *.MPD. I've looked in the PJDB.HTM but could not find out how Project
saves work values in the database.

For example:
What is the resource work in hours for the database value of 4522000 ?

TIA
 
J

JulieS

Hi Stretch,

From the Pjdb.htm file:

"Work values are saved as minutes * 1000. Eight hours would be saved as
480000 (that is, 8*60*1000)"

So your value of 452200 is 75.36667 hours.

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
 
S

Stretch

Julie,

Thank you VERY much.

Stretch


JulieS said:
Hi Stretch,

From the Pjdb.htm file:

"Work values are saved as minutes * 1000. Eight hours would be saved as
480000 (that is, 8*60*1000)"

So your value of 452200 is 75.36667 hours.

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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Setting column width in a table with a macro is not working 0
optimising space used by MPD files 3
Resources in MSP_RESOURCES table 5
mpd coruption maybe - unique ids 3
Exporting Resource Data via MPD 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Timescalevalue update gives error 1101 0

Top