Currently I am using numbers with a sample as follows

A B C D E F G H
I J
1 REG HR MAX/OT MAX/WK MAX 8 12 40
2 IN OUT IN OUT TL HRS WRKD HRS REG
HRS OT HRS

3 MON DATE 5 11 12 18 12 12
8 4
4 TUES
5 WED
6 THUR
7 FRI
8 SAT
9 SUN
The formula for mon-fri reg hrs is- min($g$1,g3)
The formula for ot is- if((g38,min($h$1,g3-i3),0)
The formula for Sat reg is- if(h7:h3)<40,min(g1,40-sum(h7:h3),0)

The Sat ot is giving me trouble under certain scenarios. This is confusing,
is there a way to attach the spreadsheet?


"Kim DuBray" wrote:



"Search33" wrote:

Hi Kim,
Can you give some more info on how your spreadsheet is set up?
where/how is the date and number of hours stored?
- Search

"Kim DuBray" wrote:

Any hours past 8 in a day is paid at 1.5
Any hours past 12 is paid at 2.0, except on Sat and Sun
Any hours over 40 in a week.
On Sat (or any day in the week where 40 hrs is met) overtime is paid at 1.5.
If on Sat 40 hours is not reached, the first 8 hours are paid at 1.0 until
the 40 hours is reached. Once 40 hours is reached, hours between 8-12 are
paid at 1.5 and over 12 at 2.0. On Sun the 40 hours rule is disregarded if it
is the sixth consecutive day and the first 8 hours are paid at 1.5 and over 8
is 2.0.

I am having the most trouble with combining the 40 hour work rule and the
sixth consecutive day rule. Can anyone help with the formula's?