pay

I have a list of data that contains an area description within the cells text string E.g. the text string is as follows 'Project Name - Area Rate - Name' From the above text string I am using an array formula to return a rate based on the part of the text that is 'Area Rate'...

Hello All! Via some google searches, I found a few similar questions answered by you fine people but didn't see my exact question and couldn't tweak on my own. Here is the scenario: Agent has an 80/20 split with the brokerage. If they sell 100000.00 house, they get 3% commission (3000) and...

I am trying to set up a time sheet that will tell me my gross pay for the total hours I worked per week. My set up A1 0 A2 0 A3 8:14 A4 8:31 A5 8:01 A6 8:06 A7 0 A8 32.87 b8 $525.87 =Sum(f15:f21)*24 =f22*61 I added...

Hi! I am starting a new job next week. I need to pay my owntaxes on my income. What is the best way to calculate tax deductions in excelspreadsheet? Thanks in advance.

I'm struggling to create a sumifs in VBA - i can easily create it in a cell but want to be able able to use it in VBA I have my code below with my sumifs statement written in theory, could someone help me to put together the sumifs statement properly and the proper Dim and Set qualifiers Sub...

James, Roy, Rich, Charles, Julie, Alice, Hector, Vinton, Kiera, and Corey are travelling. They are staying at a flat at 33 USD per day. They all have money but not equal and they are going to pay in sequence as mentioned in column. If someone don't have enough money the next person is going...

I would like help discovering why a disconnected slicer is not returning the expected data. Hopefully I’m missing something obvious. I would like to return a payment schedule based on our Accounts Payable (AP) groupings. The days to pay bucket is the Payment Date (if one exists) - Accounting...

Hi all, I have a data table that I want to be able to have drop down's to pick up as a new datasheet is created. My data table looks like this <tbody> Pay Grade Pay Scale Amount Classroom Teacher M1 10 Classroom Teacher M2 15 Classroom Teacher M3 20 Training & Learning TLR1 2...

<colgroup><col><col><col><col><col></colgroup><tbody> Table 1 data is in Sheet1 Names Date of Birth Designation Pay 1 Hari 15-06-1990 Clerk 14600 2 Ramesh 26-03-1998 Head Clerk 22000 3 Madhu 12-05-2001 Administrator 26000 4 Govinda...

Hi all. I am new to this forum. I have a worksheet where a person has to work 208 normal hours for a basic salary. If he work less than 208 but has any sunday or public holiday time then i want to take the difference of normal hours less 208. Then from there i need to pay the sunday hours at...

Good day, Is there a way to set up a security on a spreadsheet to be sold to multiple persons to prevent it being resold to those who did not pay.? I was thinking a unique security feature for each spreadsheet purchased. Thanks,

I am calculating employees PTO hours each pay period, a starting balance, earned hours and requested time off. Some employees will request up to 14 days off within the pay period but the total subtracted needs to be limited to 80 hours. My formula works in calculating a running PTO balance...

Payroll for my company is semi-monthly. The workdays 8th - 23rd are paid on the following 1st. The workdays 24th - 7th are paid on the following 15th. How do I use =today() to determine its corresponding payroll date? I've created the following that appears to work. Is there anything simpler or...

I'll try to keep it simple: I have people doing work for me. Clients pay them directly and then they pay me a fee. They pay 20% on the first 10 clients 10% on clients 11-20 Then 5% on any over 20 How do I get excel to calculate this for me. I obviously need to calculate how many clients...

Dear All, I wonder if anybody can help. We are getting a pretty difficult output from one of our surveys. It looks like this: <tbody> No Detail ON OFF T Pay P D Comment ON OFF T Pay P D Comment 1 12345 1 7 12 0 1 0 5 12 16 0.50 1 0 2 12346 2 8 10 0 2 0 7 11 20 0 1 1 </tbody> Problem...

I am creating an Excel workbook to keep track of my paychecks. I have a parent table called EarningsRates that has the following columns: Earnings Code: Code to determine the description (e.g. os1 = Overtime Shift 1, rs1 = Regular Shift 1, pto = Paid Time Off) Start Date: Date the new pay rate...

Hi guys I have a formula question I’ve been working on for a few days now and can’t seem to get my head round it, was hoping for some help. I basically have 4 customers, and we have invoices/credits due in 6 time buckets 1D though to 90+D. If at a total level I owe the customer money I pay...

Good day, I created a timekeeping and payroll in excel for our company (company cannot afford to purchase a PR software). So there are 2 files, 1 pure timekeeping (biometric records converted to number of hours) and payroll computation. The payroll computation will get the data from the...

I am looking for help with a formula that will search for the dept (i.e. 10, 20) and Acct # (i.e. N40010) in a column anywhere on the page on sheet 2 and populate the values on sheet 1. The challenge is that the acct nos. on sheet 2 are not in the same columns (columns G and H) and are followed...

I've been asked to provide a summary of payroll by department. I have timesheets (workbooks) for each employee, and a summary workbook that looks up data in each of those workbooks. Each worksheet in the Summary workbook is titled as the date of the pay period, and each employee's name is listed...