Point taken, I was trying to do the work the hard way, but after reading
both your's and Rod's suggestions, I've decided to work a little smarter.
Using the import feature and as you say a calculated field, in Excel, I can
do all I need, I just got confused in the matter of bring it all into the
project file.
Some background: I use a JD Edwards report to download from the mainframe
system the data I need (for the project file) into a csv file, this in turn
is worked on when I copy and Paste it into an Excel file, then I import it
into the the Project file.
Our IT people wont let me get it directly into the project file from the JD
Edwards system.
Thx again guys, colin D.
"Steve House [MVP]" <***@to.send.hotmail.com> wrote in
message news:***@TK2MSFTNGP14.phx.gbl...
: In addition to Rod's solution, Excel is real good at arithmetic. Why not
: just add a duration column to your Excel worksheet data table and do your
: calculation there with a simple Excel formula before importing it into
: Project?
: --
: Steve House [MVP]
: MS Project Trainer & Consultant
: Visit http://www.mvps.org/project/faqs.htm for the FAQs
:
:
: "Colin D." <***@NOSPAMpersonal.com> wrote in message
: news:8wyId.70301$***@news20.bellglobal.com...
: > Hi, a little problem, I import an Excel file into Project (2000), it
only
: > has the number of manpower and the manhours in two columns. How do I get
: > the
: > Duration field to look at these two fields and calculate the duration?
Or
: > is
: > this not possible?
: >
: > i.e 2 manpower & 16 manhours = 8 hours Duration.
: >
: > TIA, Colin D.
: >
: >
: