Our Maintenance staff have 2 different types of workweeks; one is a 40 hour
workweek and the other is a 44.5 hour workweek. The 44.5 hour workweek is
when maintenance staff is responsible for emergency maintenance on-call that
week. They are scheduled to work 40 hours and are paid a 4.5 hour stipend
for waiting for the phone to ring. If they work any part of those 4.5 hours,
the stipend is reduced by that amount. As long as they do not work over 44.5
hours, their pay is based on straight time compensation. If they work even
15 minutes over 44.5 hours, they are compensated at the time and a half
overtime wage rate on any hours above 40. I would like to have the overtime
cell on their timesheets automatically calculate their overtime hours worked.
Since we are paid based on a 2 workweek pay period I am trying to handle all
variations of their workweeks within a given 2 week pay period:

1. Non-on-call week & Non-on-call week
2. On-call week & On-call week
3. Non-on-call week & On-call week
4. On-call week & Non-on-call week


I have these staff track their on-call weeks by putting an €œoc€� in
particular cells. I figure that if Wednesday is the transition day we can
use Wednesday of each week as the €œoc€� or empty cell as one logical test.
Then I need to determine the actual hours worked to decide if we can pay
overtime for that workweek depending if they have actually worked more than
40 hours during non-on-call weeks and over 44.5 during oc-call weeks (yet
calculating it back to 40 hours).

Thank you,
Norman Maze