Creating custom 'work' fields

[Stu]

I notice there are no customized 'work' type fields. Is there a way to format
a customized number field to look like a work field, e.g. commas separating
thousands, and appending units (hrs, days, etc.)?

 

[Jan De Messemaeker]

Hi,

Duration fields are formatted like Work
HTH

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

 

[DME777]

Hi.

I am trying to create 2 custom fields.
One to manually input actual hours from an outside source (our company uses
Project Server for internal time capture/actual hours)
Another to add the Actual Work field to the hours from the outside source to
capture the work hours for the entire effort.

Using Duration custom fields works, but I want the data reflected in hour
rather than days.
How can I change just these two fields from Days to Hours?

Thanks.

 

[Jan De Messemaeker]

Hi,
You can't change only those 2 fields: all duration fields are formatted
alike (Tools, Options, schedule)
Sorry :-(

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

 

[DME777]

Thanks for the response.

Any ideas on how I can capture both Actual Hours from Project Server and
hours from an external source to show a total work effort?
Since my great idea didn't work I'm willing to try a different method if you
think you have one!

 

[Jan De Messemaeker]

Hi,

First, I foprgot to say, you can always format a text field to look the way
you like... but that may be quite a formula. But it's feasible, in my first
post I forgot about that.

Then about importing actual work from a different source: how do you see
that? With a VBA procedure? That will be absolutely necessary if you want to
manipulate Actual Work since that is not a custom field thus it cannot hold
a formula.

So, if you only want to SHOW the total (and let it have no influence on the
schedule) you can put it in a text field doing the calculatio in VBA or with
a formula
If you want Actual Work to show that figure you need the approprite etting
in Project Server AND
a solid process to not overwrite totals by Server etc.; writing values in
Actual Work can not be done by a formula as said before.

HTH




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

 

[DME777]

Hey, thanks.

This info is helpful.
I do not want to change the values int he Actual Work field, I just wanted
to use that field and add manually input info (I wasn't planning to import
data). So I think I can use the text field.
I've been playing a bit and I think I can also use the number field, I just
have to divide by 60 because the field defaults to minutes instead of hours.
I think I am on my way.

I appreciate you insight.

 

[JulieS]

Hi DME777,

Pardon me for bumping in but you may be able to show the custom
duration field hours. If you have a formula in Duration2 which adds
Duration1+Actual Work try the following:

ProjDurConv([Actual Work]+[Duration1],pjHours)

You can enter the Duration1 data in hours it just won't default to
hours, you'll need to add the "h". Once you enter the data in hours
however, future edits to the data in the field will remain in 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