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