Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have the first 5 days. I need the 6th and 7th day.
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 tue soso wed soso thur soso fri (here is where I need help) sat (and here) 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 calif overtime | New Users to Excel | |||
IRR Calculations | Excel Discussion (Misc queries) | |||
Calculations seem to be off... | Excel Discussion (Misc queries) | |||
% calculations | Excel Worksheet Functions | |||
Help with PV calculations | Excel Worksheet Functions |