pay calculation

  1. M

    Spreadsheet to calculate overtime and total hours

    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...
  2. H

    Monitoring sick pay over a rolling 12 month period - with two levels of pay

    Hi All I've been staring at this for two days and I'm stuck, hope you can help me. The company I work for looks at sickness for a rolling 12 month period. In that period, we pay 100% pay for the first 65 days of absence, 50% pay for the subsequent 65 days of absence, and then 0 after that...
  3. R

    Payroll Macros

    Hello! I was wondering if anyone has an existing macro or made one in the past for payroll. I attached a screenshot of what it would look like so you just input the time in and time out for each employee and then it would calculate the time when you hit the calculate button and add the total...
  4. N

    Formula for Calculating OT with Multiple Work Rates

    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...
  5. L

    Bi-weekly pay period

    How can I calculate the last pay day in a given month based on a bi-weekly pay period, for example July 1st was the 1st pay day of this month, how could I automatically calculate what the last pay day would be?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top