overtime calculation

Hi I am needing help to create a formula within my timesheet tracking spreadsheet to track the number of hours my team have worked during a working week to assist our accounts department to ensure they are receiving the correct pay. Our working week is Monday to Friday and we work 8 hours per...

Hi, A formula help is needed to return a result for columns E and F based on start and finish times specified in columns C and D. In actual working days, the OT01 hours should be calculated below the finish time at 9 PM. The OT02 is calculated after 9 PM and the total number of hours spent on...

I couldn't find a similar question on the board. I appoligize if this has been asked and answered. I have a sheet we use to calculate OT pay and regular pay. I am trying to convert the OT to straight time by multiplying the OT hours by 1.5 then multiply that by the straight rate. I get an...

Hi! I need a formula that will help me do the following. I have spent hours trying to figure this out but haven't found a solution. Our employees work at multiple locations with different wages at every location. I need a formula that will take the summed total hours for all locations, apply...

Shift Allocation formula = (If ENTRY is between 5am to 8am – Day Shift), else If ENTRY is between 5pm to 8pm – Night Shift; Otherwise Night Shift Note - The formula is incorrectly allocating “Night Shift” to any “Exit” as formula was focussed on capturing “ENTRY” only. Working Day [DS...

Hello I wanted some help in calculating employee overtime and time-off in lieu. I have 2 data worksheets (“Original Saturday Overtime Hours” & “Sunday Overtime Hours”) showing the number of Saturday and Sunday overtime hours respectively. They can have more than one entry in each and not...

Hello. I use this board a lot to get answers to my questions but this is my first post so please let me know if I miss anything important. I am trying to calculate some payroll figures and running into some trouble. I know this is a task that seems redundant, well it is, but we are working...

I am trying to make a timesheet that calculates overtime with the following criteria... 1. Overtime is after 8hrs on any given day. 2. Overtime is after 40hrs/week...consideration to the after 8hr criteria to ensure not duplicating overtime. 3. The after 40hrs/week overtime criteria changes if...