Time sheet calculation of shift differntial

[Brett]

I am building a time sheet that requires shift differential. If an employee
works the majority of there shift after 3:00 PM they get .05 differential.

 

[Gary Brown]

Assume:
Labels in Col A / Values in Col B
Row 1: Start Time
Row 2: End Time
Row 3: Break in hrs
Row 4: Reg. rate of pay
Row 5: Shift Differencial rate of pay
Row 6: Reg Pay
Row 7: Shift Diff pay

Cell B1: 1:00 PM
Cell B2: 9:30 PM
Cell B3: .50
Cell B4: $10.00
Cell B5: $0.05
Cell B6: =(((B2-B1)*24)-B3)*B4
Cell B7: =IF((B2-((((B2-B1)*24)/2)/24))<(15/24),0,B5)*(((B2-B1)*24)-B3)

Points to consider:
- Are OT hours figured in how long a shift is for calculating
"If an employee works the majority of their shift after 3:00 PM".
- Is Break Time figured in how long a shift is for calculating
"If an employee works the majority of their shift after 3:00 PM".
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown