Hello,

I'm looking for a formula that will calculate overtime. But here's the
problem... We do business in California and are required to pay overtime for
any hours 1.) worked over 8 hours in a day 2.) worked over 40 hours in a week
and 3.) worked on the 7th consecutive day (in our case Sunday when hours have
been worked Monday through Saturday).

I can figure out the overtime for each requirement but I'm trying to get an
overtime calculation in one cell with all three criteria being met. Any help
would be appreciated.

Thanks,
Joe D.