Calculating Weekend Overtime

[TG02]

Using the Resource usage view I add the actual hours worked on that specific
day by displaying the actual work field on the right side of the view port
and then adding the number there. I then display the overtime column and then
specify manually how many of the actual hours worked were overtime hours
(anything over 8h per day) by adding that number to the overtime column in
the same row as the task,and project will calculate the overtime cost for me
and add it to the total project cost. This works well.Here is the problem:I
want to be able to do the same thing for weekend hours.The rate for weekend
hours is a higher rate the then regular overtime rate.The problem is that in
the rate sheet there is no option to include another field with a 2nd
overtime rate.I can create a custom cost field and add the weekend overtime
rate to that but that would require a separate Weekend Overtime work and
Weekend Overtime Cost field where I would specify that, of the total actual
hours worked, x amount of hours are weekend hours and need to be calculated
using the weekend overtime rate. This would then need to be added to the
total project cost.Anyone know a workaround to accomplish this. As far as I
can tell ms project does not support this functionality.

 

[John]

Using the Resource usage view I add the actual hours worked on that specific
day by displaying the actual work field on the right side of the view port
and then adding the number there. I then display the overtime column and then
specify manually how many of the actual hours worked were overtime hours
(anything over 8h per day) by adding that number to the overtime column in
the same row as the task,and project will calculate the overtime cost for me
and add it to the total project cost. This works well.Here is the problem:I
want to be able to do the same thing for weekend hours.The rate for weekend
hours is a higher rate the then regular overtime rate.The problem is that in
the rate sheet there is no option to include another field with a 2nd
overtime rate.I can create a custom cost field and add the weekend overtime
rate to that but that would require a separate Weekend Overtime work and
Weekend Overtime Cost field where I would specify that, of the total actual
hours worked, x amount of hours are weekend hours and need to be calculated
using the weekend overtime rate. This would then need to be added to the
total project cost.Anyone know a workaround to accomplish this. As far as I
can tell ms project does not support this functionality.

TG02,
Unfortunately you are correct in that Project does not support multiple
overtime rates. This is definitely an oversight in Project's
functionality since many if not most companies have separate rates for
"normal" overtime, (typically time and a half), and weekend or holiday
overtime, (typically double time). However, you can get there, it just
requires a little more work.

I can't think of any way to do it with one or more formulas in spare
fields. For one thing Project does not support formulas for assignment
spare fields. Second, there is no way to use time-scaled data in
formulas - at least that I can think of.

The best way to do what you want is via a VBA macro. Here is one
suggestion of pseudo-code to set it up.
1. Designate a spare field to capture the normal cost calculated by
Project (regular hours plus overtime) plus weekend overtime calculated
by the macro code
2. Use a spare resource cost field on the Resource Sheet to enter the
weekend rate. If you want to use a factor instead of an actual rate,
(e.g. 2 times normal rate), then use a spare resource number field.
3. In VBA loop through all assignments of each resource and look for
overtime hours, (entered in the normal overtime timescaled field on the
Resource Usage view), that were entered for weekend days
4. Use the data from 3 above to calculate the cost based on the weekend
rate and add it to the normal cost field. Put the result in the spare
field designated in 1 above.

Hope this helps.
John
Project MVP