payroll

I am a fractional CFO who is familiar with Power Query and its capabilities but have not been able to apply it in practice. One opportunity I see for PQ is to automate a monthly payroll entry I have to make to "close the books" for multiple clients. The client has many departments and close to...

I receive the total pay for an employee and the pay rate. What formula can I use to come up with the hours taking in to account overtime?

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

I am new to VBA. I will need your assistance in building a VBA the will automatically import and perform the tax calculations. Thank you and I will really appreciate your assistance.

i am preparing payroll sheet. there is mastersheet where all employee data available and there are 12 sheets for attendance and salary. if any employee leave the job his data wont be showup in further month in aatendace and salary sheets but his past month data must be there for records.. how...

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

Hi I have a spreadsheet that comes every month with a lot of payroll data on it. I need to update a master sheet that holds summary details each month. My problem is that the data in the columns from the payroll spreadsheet can be different each month eg month 1 col D may have OT1 but next...

So I have somewhat of a complex requirement that I need some help with in VBA. I currently have 1 Workbook (Payroll Tracking) which as you can imagine, tracks payroll numbers. Haha. What I would like to have it do, with a command button is to copy/paste (Values) from 1 table to a new workbook...

Trying to piece together a formula that will combine a bit of text with COUNT results from a worksheet called 'payroll'. Perhaps I should start with what I want the finished result to look like. The formula, which is on a worksheet called 'income_analysis', would return the following...

Hello, I have a table countries and jobs in that country. I am looking to select the job and get all the countries that job is in. Example: select Janitor and the output will show USA,China and Canada <tbody> USA Spain China Canada Mexico Janitor Payroll Janitor HR Manager Operator...

Hello all, I am running a VBS macro in our ERP that opens a target Excel Document and populates the form with data from a workbook. The program works but the execution time is roughley 1 and a half minutes. I placed some MsgBox's throughout the script to see where the lag was comming from...

Hi all, I would like to use a VBA code so that to clear the numbers’ decimals which contains space before comma e.g. 26 ,7 should be 26 Therefore that, the code should run through col. “C4” : “O” and rows down. Please see below an extract of original data and the expected result. Thank you...

I have searched the web for a solution to my question with no luck. Here is my issue: I have cell A1 with a date (any date), I also have two named ranges. One named Holidays and the other one named Payroll. They are used to identify the company's holidays and the payroll dates. I need to...

Hi all, I tried looking for an answer myself (or here), but I just can't get it to work. Hopefully the answer is understandeable for a non-IT guy (finance background)... :-) So the problem: We have about 100 employees working on our payroll and we want to allocate their individual cost to...

I have a payroll workbook that has 26 payroll worksheets and an OT Totals worksheet at the end. I'm trying to figure out a formula in the OT Totals worksheet that will find an employee's last name in each worksheet and total their Reg OT. Last year I just made a formula by going to each...

I am trying to use the below code to download a list of daily reports from password protected sites. The server seems to be blocking the request. I have no issues when manually logging in to download each report. I am using Excel 2013 and not positive that this is the correct WinHTTP...

<tbody> weekly salary ee er weeks salary 200-339.99 11.9 23.8 4 340-449.99 17.4 34.8 450-609.99 23.3 46.6 610-759.99 30.1 60.2 </tbody> hello so i need aformula to say if my salary is 600 then use ee b3 also multiply ans by d1

Hi all, I would like to use a VBA code so that to “revise” the numbers in col. “J” if the account in col. “E” is “450102 ADMIN”, “450102 RES”, “605102 ADMIN” and “605102 RES” Therefore, that should make the proper deduction and then should turn the negative number into positive. Below I present...

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