payroll

  1. R

    Overtime payroll sheet nightmare!

    Hi I am trying to create an overtime sheet for my Hospital's salaries department and I am stuck! They need to have an out put of the exact hours worked (eg 09:00-17:00) for each day. Some people my work onsite in the hospital on several occasions per day so the exact hours for these need to be...
  2. Z

    Formula for Counting No. of Hours Worked Based on Se Schedule Excluding Time Outside of Schedule

    Hi, everyone. Sorry if the title is kinda vague, but what I was trying to do is coming up with a formula for computing the number of work hours for each employee based on their schedule against their timestamps. Then, also compute their lates and absences. Here's how my tables would look like...
  3. M

    Apply background fill color to a range based on cell value

    We use alternating background fill color in columns A-G as a visual reference to distinguish between rows with certain payroll date values stored in G. Currently, we have 2 macro buttons that each apply 1 of the colors. I'd like to incorporate this functionality into the vba language, so we can...
  4. B

    Comparing totals via conditional formatting

    Hi, I am looking to utilize conditional formatting to color code a set of totals compared between 2 payroll systems. The one payroll system pays by the minute and will have the format 37:47 for example to show 37 hours and 47 minutes worked that week. The other payroll system rounds to the...
  5. A

    percentage round up to nearest decimal point with range

    <tbody> Salary 11% Payroll Website Result RM 3460 RM 380.60 RM 381.00 RM 3470 RM 381.70 RM 383.00 RM 3480 RM 382.80 RM 383.00 RM 3490 RM 383.90 RM 385.00 </tbody> dear all, I'm doing a manual excel formula payroll therefore I faced an issues that the calculation of 11%...
  6. J

    SUMPRODUCT help

    Hi there, I've exhausted my options and really need some help with this. I'm dealing with a fixed payroll table where the column headers duplicate across (but the data is different). Given a bi-weekly income, I want to calculate what the CPP amount is. For example, if income was $2,011.45...
  7. F

    Vlookup or Index/Match?

    Hello Excel gurus, I am doing our employee database maintenance between our Payroll Database and NetSuite database. However, I am running into some issues that I need your expert help. The problem I have is our payroll database have employees (without middle name initial) and correct updated...
  8. megera716

    Why can't I group or subtotal sums in my Pivot Table?

    Payroll items on the left, departments across the top: I want to group the FUTA, MED and SS into an "Employer Taxes" group and the other 3 payroll items into an "Insurance Premiums" group, but I can't! When I select more than one row label and right-click the option just isn't there...
  9. M

    Dealing with changing formula reference paths in shared folders

    We have a main payroll workbook that pulls data (a mileage total) from a closed workbook in a shared folder. Several of us take turns running payroll, and the reference paths fall apart if the payroll is run from a computer other than the one at which the formula references were entered. I am...
  10. A

    Convert payroll hours to decimal

    hello and thanks for helping I am trying to convert payroll hours to decimal, getting stuck when hours are over 24 example DATA in cell A1 = 30:30 would like end result in cell B1 to = 30.5 this formula is only good up to 24 hours " =(A1-INT(A1))*24 " i am open to new ideas on this thanks...
  11. T

    Formula to insert text

    I have a workbook that has 20+ tabs of profit and loss information for different cost centers. I want to add text in a column A based on what the formula finds in column B. I think I should be using Match/Index but can't quite figure it out. So....directly below is my reference information...
  12. A

    Employee Overtime/Shift differential

    A B C D E F G H Name Start End hours worked Straight Shift Diff OT Shift Diff OT MR A 02/25/2018 06:10 02/25/2018 18:40...
  13. P

    Matching on 3 Criteria Formula Troubles

    Hello, I'm trying to match on 3 criteria to return a result, but no matter what I have tried it hasn't worked. In the example attached I am trying to match "Rms Cable Television", "Jan-18", and "ACTUAL" (all in bold below), to return a value. The formula I am attempting to use is...
  14. Z

    Formula ? about Range

    Is there any way to put into this formula to extend the higher range out further. =SUMIFS(Summary!$C$4036:$C4145,Summary!$B$4036:$B4145,"Hudson C") Here is my issue if I need to insert more rows on sheet "Summary" and add more info. The C4145 and B4145 wont go higher. I am trying not to go all...
  15. S

    Slow running Workbook Open macros

    Hi All I have inherited a workbook to sort out which with my limited knowledge of Excel is causing me a bit of a headache. Upon opening the workbook updates a list of names from an external source (another workbook) and then asks for the user to enter their payroll number which it validates...
  16. K

    Formula Needed for Bonus Allocation

    I am trying to figure out a way to create a sheet for calculating bonus allocations from a sheet of data used to allocate payroll. Here is what the payroll sheet looks like: <strike></strike>And the formulas I need would produce a list of employee ids and their entity allocation like this: I...
  17. S

    Conditional Formatting using a lookup formula

    Hello, I need some help using conditional formatting. I have a spreadsheet with employee payroll data. In column A I have a formula that numbers the row. I did this, so that when I filter the data based on salary amount over a $ threshold, I could have a numbered list. The formula that I have...
  18. L

    Sumproduct multiple criteria

    <tbody> A B C D E F G H I 1 Team ID Name SickCalls Incident ID Name Date 2 Peter 1 Ana 2 SICK 1 Ana 01/02/2017 3 SICK 1 Ana 01/03/2017 4 SICK 1 Ana 01/23/2017 </tbody> Good evening, On cell D2 i have the following formula...
  19. S

    Payroll budget

    Hi, I am trying to create a payroll budget spreadsheet. I have the following data A,B,C Employee Start Date, Employee End Date, Gross Salary I want to then put in a monthly budget in month cells which are labeled November 2016, December 2016, January 2017 etc... So for instance if I have...
  20. J

    Sorting payroll worksheet alphabetically using VBA

    Hi, I have almost no knowledge of VBA, and need help with this. I have a payroll spreadsheet with monthly worksheets containing employee codes, names, hours worked per day, overtime calculations, Sunday pay calculations, etc. I need help with the ffg: 1. For every month's worksheet I need to...

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