Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculating overtime | New Users to Excel | |||
Calculating overtime | Excel Discussion (Misc queries) | |||
Calculating Overtime | Excel Worksheet Functions | |||
Need help calculating overtime to date | Excel Worksheet Functions | |||
Calculating overtime | New Users to Excel |