Timesheet Differential

%3CLINGO-SUB%20id%3D%22lingo-sub-3304846%22%20slang%3D%22en-US%22%3ETimesheet%20Differential%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3304846%22%20slang%3D%22en-US%22%3E%3CP%3EI%20could%20use%20some%20assistance%20regarding%20a%20formula%20that%20accounts%20for%20hours%20worked%20differential.%3C%2FP%3E%3CP%3ECriteria%20%3A%3C%2FP%3E%3CP%3EDifferential%20pay%20is%2010%25%20of%20hourly%20pay%20%2B%20hourly.%20%26nbsp%3BSO%20employee%20makes%20%2410%2Fhr%20would%20get%20paid%20%2411%2Fhr%20%26nbsp%3B%3C%2FP%3E%3CP%3EDifferential%20hours%20are%20any%20hours%20worked%20between%2010pm%20-%206am%20on%20any%20day%20of%20the%20week%20but%20has%20to%20work%20at%20least%20for%20an%20hr%20so%20some%20who%20clocked%20out%20at%2010%3A30%20pm%20would%20not%20get%2030%20mins%20of%20diff%20pay%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Image%205-4-22%20at%2011.21%20AM.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369205iF51B5BFFECE85FB1%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Image%205-4-22%20at%2011.21%20AM.jpg%22%20alt%3D%22Image%205-4-22%20at%2011.21%20AM.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOT%20is%20any%20volunteered%20shifts%20outside%20of%20the%20scheduled%2040%20hour%20work%20week.%20Once%20they%20hit%2040hrs%20they%20get%20time%20and%20a%20half.%20Diff%20pay%20is%20always%20based%20off%20base%20rate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20already%20worked%20out%20negative%20time%20for%20the%20shifts%20that%20span%20past%20midnight%20and%20I've%20accounted%20for%20the%2040%20hour%20work%20week.%20Not%20sure%20where%20to%20start%20on%20the%20differential%20formula.%20Any%20help%20would%20be%20much%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3304846%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

I could use some assistance regarding a formula that accounts for hours worked differential.

Criteria :

Differential pay is 10% of hourly pay + hourly.  SO employee makes $10/hr would get paid $11/hr  

Differential hours are any hours worked between 10pm - 6am on any day of the week but has to work at least for an hr so some who clocked out at 10:30 pm would not get 30 mins of diff pay

Image 5-4-22 at 11.21 AM.jpg

 

OT is any volunteered shifts outside of the scheduled 40 hour work week. Once they hit 40hrs they get time and a half. Diff pay is always based off base rate.

 

I have already worked out negative time for the shifts that span past midnight and I've accounted for the 40 hour work week. Not sure where to start on the differential formula. Any help would be much appreciated.

0 Replies