Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Complex overtime calculation | Excel Worksheet Functions | |||
Overtime Question Unlike Others (Pictures Included) | Excel Worksheet Functions | |||
Hide Rows / Columns - complex question | Excel Worksheet Functions | |||
Complex query question | Excel Worksheet Functions | |||
complex count question | Excel Worksheet Functions |