payroll

  1. S

    15th & EOM pay schedule

    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)...
  2. W

    Formula that will take me to the next pay period end date.

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

    Convert time clock ins (1/60) to 1/100 with formula

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

    Payroll Spreadsheet

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

    Consolidate Data in Excel; Payroll

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

    Sum Pay/Day/Month

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

    Payroll Sunday hour calculation from in and out times

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

    Conditional Formatting Question Based on Birthday

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

    Payroll and Time without a colon

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

    How to calculate overlapping hours between departments

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

    Overlapping hours more than 37 hours paid in a 24 hour period

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

    Dynamic payroll system which calculate total hoursof regular, night shift, overtime and overtime night shift.

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

    Needing help with a payroll formula fast

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

    Creating User Form to input payroll hours for a 2 week period

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

    Replicating Payroll Deductions Online Calculator results

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

    Complex overtime worksheet

    <?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...
  17. cgeorge4

    MacroProblem: Select/Activate Specific Row then Copy Format/Formula to All Blank Rows

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

    Running Totals Calculating Overtime?

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

    ifsum or ifcount formula

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

    Payroll - Daily & Weekly Overtime

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

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