Complex overtime calculation
 

I'm trying to figure out how to do an overtime calculation for Calif. On the
seventh consecutive workday, (provided all of the previous six days have at
least one hour worked) the overtime hours are 8 and the remaining hours
worked are paid at double time. However, if any of the previous 6 workdays
have 0 hours worked then the calculation is to pay the difference between 40
and the total reg hours for the week as regular, the next 4 hours as ot and
any additiional as double time.
I've created the two scenarios as separate functions, but can't figure out
how to combine them into one formula.

Complex overtime calculation
 

Post the two formulae and let's see if we can combine them.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kim DuBray" <Kim wrote in message
...
I'm trying to figure out how to do an overtime calculation for Calif. On
the
seventh consecutive workday, (provided all of the previous six days have
at
least one hour worked) the overtime hours are 8 and the remaining hours
worked are paid at double time. However, if any of the previous 6 workdays
have 0 hours worked then the calculation is to pay the difference between
40
and the total reg hours for the week as regular, the next 4 hours as ot
and
any additiional as double time.
I've created the two scenarios as separate functions, but can't figure out
how to combine them into one formula.

Complex overtime calculation
 

Kim

Check out Chip Pearson's timesheet site.

http://www.cpearson.com/excel/overtime.htm


Gord Dibben Excel MVP


On Wed, 7 Dec 2005 15:24:02 -0800, "Kim DuBray" <Kim
wrote:

I'm trying to figure out how to do an overtime calculation for Calif. On the
seventh consecutive workday, (provided all of the previous six days have at
least one hour worked) the overtime hours are 8 and the remaining hours
worked are paid at double time. However, if any of the previous 6 workdays
have 0 hours worked then the calculation is to pay the difference between 40
and the total reg hours for the week as regular, the next 4 hours as ot and
any additiional as double time.
I've created the two scenarios as separate functions, but can't figure out
how to combine them into one formula.