payroll

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

I have scanned related posts and still do not find an answer for our need. New payroll system and I need to oversee my team for paydays, reporting time, etc. 1) Pay dates are 15th and EOM (Sun/Hol pay proceeding Friday). 2) Administrator needs exceptions/hours 4 work days prior to pay date. 3)...