Convert the units of Work from Dys to Hrs?

B

bradsaxon

How do I convert the units of Work from Dys to Hrs? I see where you can run a
similar macro for Duration, but I need to convert the Work field?

Also, can someone please define (for my simple mind) how the following are
being figured:

I have a task with a Duration of 19 dys. I have 7 resources dedicated 100%
to the completion of that activity. Resulting "Work" is 133 days or 1064
hours. I can't seem to figure out the math.

Thanks in advance!

Brad
 
J

JulieD

Hi Brad

to convert work from days to hours choose tools / options / schedule - work
is entered in and set it to hours.

also the formula in project for work is
Work = Duration * Units

so
Work = 19D * 7 (units)
= 133d

and if your days are 8hrs long
Work = (19*8)*7
= 1064hrs


Hope this helps
Cheers
JulieD
 
S

Steve House [MVP]

8 working hours per day * 100% units * 19 days duration = 152 man-hours work
performed per resource
152 man-hours work/resource * 7 resources working = 1064 total man-hours
work expended
 
B

bradsaxon

Julie - You rock!! Thanks!

Brad

JulieD said:
Hi Brad

to convert work from days to hours choose tools / options / schedule - work
is entered in and set it to hours.

also the formula in project for work is
Work = Duration * Units

so
Work = 19D * 7 (units)
= 133d

and if your days are 8hrs long
Work = (19*8)*7
= 1064hrs


Hope this helps
Cheers
JulieD
 
B

bradsaxon

Steve -

Thanks for the response. I am still trying to figure out the math. Thanks to
Julie, I now have Work in Hours - Thanks Julie! I have a task with a Duration
of 48 hours. I have 11 people assigned at Units of 2% and the Work is now
10.57 hrs. I guess maybe understanding how Units work might be helpful.

Thanks in advance!

Brad
 
S

Steve House [MVP]

It is essential to understand that duration and work are not the same
measure. Duration measures time but work measures sweat. That is why I
always try to refer to duration by "hours" but work by its proper unit
"man-hours." If you had 1 man working full speed for 1 day, you have 1
man-day of work. If you have 1 man working full speed for 10 days, you have
10 man-days of work. BUT, if you have 10 men working full speed for 1 day
you ALSO have 10 man-days of work. Work measures the total useful output
you're getting and duration measures how long it takes to get it.

The units is a percentage that reflects how much of the duration is getting
translated into useful work output and so indicates the rate that work is
getting done. The Prime Directive is Work=Duration*Units. If I work 8
hours duration at 100% units, I do 8 man-hours of work. But if I do 8 hours
of duration at 50% units, I only do 4 man-hours of work. Maybe I'm talking
with my buddy and not working at full speed. Or maybe I'm juggling two
things at once and can't really devote full attention to either of them and
as a result each of them takes me longer to complete than if I was working
on just that one thing. If I have 1 person doing 10 days duration (80
hours) at 2% units, he does 80*.02 or 1.6 man-hours of work, spread out over
the 10 days of working time. In other words it has taken him 10 days to
achieve what WOULD have only taken an hour and a half if he had devoted his
full attention to it. 11 people working 48 hours duration at 2% units each
is 48 * .02 * 11 or 10.56 man-hours of work - the team is taking over a week
to accomplish what should have taken them only an hour if they had got their
act together and pulled together as a team to get 'er done ASAP.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs
 
J

JulieD

Hi Brad

glad it's solved ... btw you might like to have a look at a series of
article that Mike Glen has written at www.tinyurl.com/2xbhc it contains a
lot of very useful information on how project works & thinks.

Cheers
JulieD
 

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

Top