payroll

I'm trying to create a formula that will take me to the next pay period end date. For example, if the employee's leave of absence is going to go unpaid effective 1-1-15, I want a formula that will tell me when the last day of the pay period is for 1-1-15. We have a biweekly pay periods...

Hello! I am new here, but excited I found this forum. Your help is greatly needed! I just started at a new company and they had not been converting the numbers from 1/60 to 1/100 for the paychecks for over 6 months. There are a lot of employees and doing everyone by hand would take days. Could...

Hello Hello, I am creating a spreadsheet for my company's payroll, and I need a formula to work out the overtime that is different at different rates ie Monday to Saturday are - the first 4 hours after their contracted 8 hours is at 1.5 then the rest is at 2, then night shifts are first 4 hours...

Hello! I am updating a payroll document that we use for the company that I work for. Right now, we have multiple documents that we "carry" numbers around to suit the needs of different departments. I would like a more efficient system where I only have to enter the numbers once, and they...

Hey everyone, Newb here, I am currently looking for a monthly payroll formula. I looking through inter-webs, though I'm have not been able to find one applicable to my situation. The scenario is: 1st table "Start Date"; "End Date"; "# of Day Off"; "Total Days Worked"...

Hello, I have been looking for a solution from this forum but I havent found anything proper. I am having some troubles with calculating sunday hours from in and out times. Basically what I am looking for is something like this. EXAMPLE: <tbody> IN OUT SUNDAY HOURS 23.3.2014 09:00...

I'm sorry I can't find an answer to this, but I have a spreadsheet that I work off of for each pay period at my company, and in it there is a column for the employee dates of birth and a column for age. There are also two cells at the bottom of the worksheet that are pay period start date and...

So I have timesheet that is working pretty awesome however for data entry I want to be able to not have to use the Colon (:) when entering time. I figured how to do that, but it does not add my time up correctly when I changed it. I currently use =MOD(C6-C5,1)*24 to add the hours up, and my...

Hello, I have an employee working 37 hours per day by accident, (even though there are 24 hours) I used military time. Column A is the month/day/year Column B is the Department 1 In Time Column C is the Department 1 Out Time Altogether there are about 15 departments with In and Out times...

Hello, this is my first post. I need some help. This is a problem to be solved and it has been awhile since I had to calculate something this complex. The sales person is in a store working but the time sheets show more than 24 hours per day, up to 37 hours working and paid for. The scenario...

Hello Masters, Can somebody advice me how to do this payroll system which will look like this <tbody> Name Date Time In Time Out Regular Night Shift Regular Overtime Night shift Overtime j doe 04/04/2013 14:00 01:00 7 1 0 2 </tbody> Regular rates starts from 6am to 10pm. Night Shift with...

Attached is a prntscr of my workbook, Im wanting to start by writing a formula for Patti Stonesifer (the 1st employee in the worksheet)’s gross pay in the Gross Pay column. Regular pay is the employee’s pay for up to 40 hours and is computed as hourly rate * hours worked. Overtime pay is paid...

I am wondering if this is even possible. Here is the scenario: I have a workbook with 3 sheets: Employee and Rate; Date,Pay Period, and Month; and then a third sheet to capture data which has Employee, Date and HoursWorked. What I would like to do is create a user form that can input the...

Dear Colleagues, Has anybody tried and succeeded in creating a spreadsheet where one could enter weekly (bi-weekly, semi-monthly, monthly etc.) wages, and get federal (Ontario) tax exactly the same as in Payroll Deductions Online Calculator at...

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I can calculate my overtime into 2 diferrent rates including weekends, but I need to enter manually any 2UP (Row/Cell AH) or Wait time hours (Row/Cell AM)which both need to be deducted from the daily hours...

<TABLE style="WIDTH: 528pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=704><COLGROUP><COL style="WIDTH: 48pt" span=11 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt...

Hi Everyone! Hope someone can help with this. I am having a hard time wrapping my head around it, so anything will be useful! Thanks in advance! I need to track employee overtime that needs to be used in 3 months, for example: Employee A: did overtime on July 1 for 8 hrs, which is banked at 12...

Okay, In cell E17 I am trying to say that if the data in cells P17-T17 are greater than 8, then the sum of what is greater than 8 will go in E17.. basically, overtime is anything over 8 hrs a day, cells p17 through t17 are the days of the week.. if any of them are over 8, then i need what is...

(This is Sooo Bad, I had all this typed and lost it in the preview) (This time I "ctrl+c" everything before preview) (In preview my pic didn't show, I used the wrong link: "Use the second one") I am creating a weekly expense report that includes pay Daily Hours <= 8 $10.00 Daily Hours > 8...

Hi all, I need to convert a time into a decimal, but also add a specific rounding function. For example, A1 shows the hours and minutes worked in the form of 8:39 (meaning 8 hours, 39 minutes). I want to convert this to a decimal in B1 and also round to the nearest quarter hour. Where...