Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time sheet calculation | Excel Discussion (Misc queries) | |||
Time Card Calculation Spread Sheet | Setting up and Configuration of Excel | |||
time shift and salary calculation | Excel Discussion (Misc queries) | |||
Time Sheet Calculation | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions |