Time sheet calculation of shift differntial
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. |
Time sheet calculation of shift differntial
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 "Brett" wrote: 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. |
All times are GMT +1. The time now is 11:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com