Hi Joe

Nothing would beat a supersexy oneliner here, but for a task like this I'd
probably go for a lot of helper cells, some dealing with its own single
requirement and others coordinating them.

I think you must post pretty detailed where what is entered how to get
working suggestions on this, there are all kinds of timesheets out there.

HTH. Best wishes Harald

"Joe D." <Joe skrev i melding
...
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.