Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2012, 04:06 AM
user0044 user0044 is offline overtime work effecting task duration Windows XP overtime work effecting task duration Office 2012
Novice
overtime work effecting task duration
 
Join Date: Feb 2012
Posts: 9
user0044 is on a distinguished road
Default overtime work effecting task duration

Hi

In MS Project 2007, when you change overtime work, why task duration gets changed? - this is strange!

The duration comes to less than 1 day (in decimals) when i increase the overtime work!!



thanks
hammad
Reply With Quote
  #2  
Old 02-25-2012, 07:49 AM
JulieS JulieS is offline overtime work effecting task duration Windows 7 64bit overtime work effecting task duration Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Assigning overtime work always drops the duration of tasks. The amount of overtime is deducted from the total work on the task and the lower number is used to recalculate duration. Overtime is considered "off the working calendar".
Reply With Quote
  #3  
Old 02-25-2012, 11:21 AM
user0044 user0044 is offline overtime work effecting task duration Windows XP overtime work effecting task duration Office 2012
Novice
overtime work effecting task duration
 
Join Date: Feb 2012
Posts: 9
user0044 is on a distinguished road
Default overtime work effecting duration

Hi JulieS

Thanks for the reply. I have a little understood you.

Why by increasing overtime work the assignment percentage only gets increased? If it was 100%, after increasing overtime work, that becomes 120% for example, because the resource is working more than the default work hours or what is defined in his calendar, right?

What's the point of decreasing the duration, i am not getting it, can you please elaborate a bit more?

thanks
Reply With Quote
  #4  
Old 02-25-2012, 11:27 AM
JulieS JulieS is offline overtime work effecting task duration Windows 7 64bit overtime work effecting task duration Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

It sounds like you are not really using the Overtime Work field -- just increasing a resource's hours per day?

If you are using Overtime, you have to assignment it to the task specifically. Increasing the number of hours the resource is scheduled (in the Task Usage or Resource Usage view) just increases assignment units.

You are correct, assignment units over 100% means that the resource can create more than 8 hours of work (effort) in an 8 hour duration.

Decreasing task duration means the finish date moves in (earlier). If you start moving the finish date of tasks in then you might be able to finish the project earlier.
Reply With Quote
  #5  
Old 02-26-2012, 08:03 AM
user0044 user0044 is offline overtime work effecting task duration Windows XP overtime work effecting task duration Office 2012
Novice
overtime work effecting task duration
 
Join Date: Feb 2012
Posts: 9
user0044 is on a distinguished road
Default

Hi JulieS

No, I am changing a value Overtime work column in the Resource Usage View and this is effecting the task duration.

please guide in this regard

thanks
Reply With Quote
  #6  
Old 02-27-2012, 06:29 AM
JulieS JulieS is offline overtime work effecting task duration Windows 7 64bit overtime work effecting task duration Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

As I explained, overtime work always decreases duration -- however it should not be changing assignment units.

Perhaps if you tell me what you want to accomplish, I can be of more help. But again, assigning overtime work will change the task duration.
Reply With Quote
  #7  
Old 02-27-2012, 11:14 AM
user0044 user0044 is offline overtime work effecting task duration Windows XP overtime work effecting task duration Office 2012
Novice
overtime work effecting task duration
 
Join Date: Feb 2012
Posts: 9
user0044 is on a distinguished road
Default

Hi

But i didn't understand why overtime work changes duration. What is the relation between them. And is there a formula, how overtime work effects the duration value?

practically speaking, if a resource works 8 hours, 10 hours or whatever hours in a day, the duration remains the same 1 day. Similarly if a resource works 8 hours and does 2 hours overtime, the duration still remains 1 day, by adding 2 hours overtime work duration doens't change... but why then it does in MS Project?

thanks
Reply With Quote
  #8  
Old 02-27-2012, 12:40 PM
JulieS JulieS is offline overtime work effecting task duration Windows 7 64bit overtime work effecting task duration Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

If you have a task of one day duration and assign one resource at 100%, Project calculates the work = duration * assignment units.

So, 8 hours of work for one resource at 100%. So now you decide to assign two hours of overtime. By assigning overtime project subtracts the 2 hours of overtime from the 8 hours of "regular work" equaling 6 hours. The definition of a day by default is 8 hours (set in Tools > Options, or File > Options in 2010). So there are now 6 hours of regular work and two hours of overtime. The 6 hours are now used to recalculate duration.
6/8 = .75 days

Again, there is a significant difference between assigning overtime and tracking overtime. If you originally had the resource scheduled for 8 hours of work and you enter 10 hours of actual work, Project will increase the assignment units. If you enter 8 hours of Actual Work and 2 hours of overtime, the assignment units will stay at 100% without triggering an overallocation.

It really does matter where you add the overtime and whether you add it to the Overtime work field or Actual Overtime Work.

I hope this helps.

Julie
Reply With Quote
  #9  
Old 02-28-2012, 05:46 AM
user0044 user0044 is offline overtime work effecting task duration Windows XP overtime work effecting task duration Office 2012
Novice
overtime work effecting task duration
 
Join Date: Feb 2012
Posts: 9
user0044 is on a distinguished road
Default

Hi JulieS

I am trying to understand this. But really the "regular work" should remain constant at 8 as it is regular. .Overtime work shouldn't change it.


Hammad
Reply With Quote
  #10  
Old 02-28-2012, 07:05 AM
JulieS JulieS is offline overtime work effecting task duration Windows 7 64bit overtime work effecting task duration Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Hi Hammad,

I'm afraid that is not how Project deals with it. Work is the sum of regular + overtime work. So assigning overtime decreases regular work. This is just how Project chooses to calculate it.
Reply With Quote
  #11  
Old 03-06-2012, 12:09 AM
user0044 user0044 is offline overtime work effecting task duration Windows XP overtime work effecting task duration Office 2012
Novice
overtime work effecting task duration
 
Join Date: Feb 2012
Posts: 9
user0044 is on a distinguished road
Default

Hi JulieS

Thank you for your guidance


hammad
Reply With Quote
  #12  
Old 03-06-2012, 07:20 AM
JulieS JulieS is offline overtime work effecting task duration Windows 7 64bit overtime work effecting task duration Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You're welcome and thank you for the feedback.
Reply With Quote
Reply

Tags
overtime work

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Task duration between 2 fixed milestones cettolox Project 3 01-24-2012 06:33 AM
overtime work effecting task duration Task cannot stop once started, but cannot continue into non-work hours sullied Project 3 12-05-2011 06:32 PM
Work not changing duration benoldays Project 0 02-14-2011 08:21 PM
Work as percent of another task JohnG10 Project 0 12-10-2010 07:51 AM
Duration changes fail to update work effort Panteledes Project 6 05-25-2010 02:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft