Isn't it just a matter of summing all of the non-overtime attributed time
and work it from there?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
...
I have the first 5 days. I need the 6th and 7th day.

I just don't have that big of brain.

Thanks

--

Chase Michaels

"Bob Phillips" wrote in message
...
1.5 times

=MIN(MAX(E3-8,0),4)

2 times

=MAX(E3-8-G3,0)

where G is the 1.5x, and I make it 3.5 at 2x not 1.5


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



wrote in message
...
If they have less than 40 regular hour on the sixth day, then its
regular up until 40 then 1.5x. Same thing applies to the seventh day 48
hours. A work day consists of at least 8 hours.

One and one-half times the employee's regular rate or pay for all hours
worked in excess of eight hours up to and including 12 hours in any
workday, and for the first eight hours worked on the seventh consecutive
day of work in a workweek; and
Double the employee's regular rate or pay for all hours worked in excess
of 12 hours in any workday and for all hours worked in excess of eight
on the seventh consecutive day of work in a workweek.

Start Lunch End Total Reg 1.5x 2x

Sun 6 1 18 11 8 3
Mon 6 1 22.5 15.5 8 4 1.5

I am using fractions ie (17.25= 5:15 pm) not hours. If someone has this
it would help me out so much.

Thank you in advance

Chase Michaels