overtime

  1. G

    Hours Worked During Day Shift / Night Shift & Overtime Earned During Day Shift / Night Shift

    I have browsed these forums looking for an answer, and nothing is exactly what I'm looking for. Hopefully I'm just not seeing and one of you can help me out. Constraints: Regular Work Day = 8 hours Day Shift: 06:00 - 18:00 Night Shift: 18:00 - 06:00 Over Time: Anything past 8 hrs Day...
  2. E

    Calculate daily hours

    I have a spreadsheet that has hours worked by a job on a daily basis. Example Monday Framing, Drywall, Stocking, Clean up 2, 4, 2, 3, 5 = 16 hours worked 8 hrs regular 4 hrs overtime 4 hrs DB time How do I calculate the number of hours for overtime, and double-time? It's a rush job and...
  3. H

    calculating overtime

    So I have a spreadsheet to keep track of my time at work. It goes In - Out, In - Out, Total (time I clock-in in the morning then out at lunch then back in after lunch and out for the day). My total time formula for the day is represented as =SUM(B1-A1)+(D1-C1). My cell format is [h]:mm and so...
  4. J

    Formula for Calculating Overtime and Premium Time

    Hello, I'm looking for a formula that will multiply a value based on the time codes of Regular (no multiplier), Overtime (1.5 multiplier) and Premium(2 multiplier). The download from our accounting software displays as follows: <colgroup><col><col></colgroup><tbody> Type Hours...
  5. T

    Select Case - Squishy spot on forehead

    After digging through umpteen references - I'm still trying to figure out what I'm doing wrong here. Per the comments in the code: I have a workbook where on one worksheet there is a named range - _FST with a drop down select for yes or no. Based on the answer I want to perform a SUM of 40 -...
  6. O

    display specific data from a group of cells

    I have data is three cells (M15, M27 & M39). They may have various text in them, but only one cell will be either "Overtime" or "PointinTime". In cell M44 I would like to display the data from whatever cell contains the either the word Overtime or PointInTime. I am unsure how to do this. I...
  7. O

    complex if/then and also reference another worksheet

    Below is the current If statement that I am using-- Sample of file format: A B ColumnC ColumnD ColumnE ColumnF ColumnG 62 Task 1 $500 63 Task 2 $850 64 Task 3 $900 What I am trying to do: If ColumnC = "Yes" then "Recognize Revenue OVERTIME". If...
  8. B

    calculating worktime and overtime

    I'm trying to calculate overtime and working time based on the start time and stop time given. The criteria are: Valid working time is between 07:00 and 17:00 all other time outside this slot is overtime. to calculate the time is not the issue, it is when somene starts or stops the time outside...
  9. H

    How to make automated hour calculation

    Im trying to build a way, how to derive from overtime hours regular working time. The rationale is that the regular working hours would be clearly visible. Example: I enter overtime work info 18:00-21:00 (3 hours), and excel calculates that work start time must have been 09:30 and end time...
  10. S

    Using SUMPRODUCT to look up a date in a range and return a value???

    Hi there. I am attempting to create a loop using SUMPRODUCT to find a date within a date range for an employee number and returning a value. This is my situation. I have an overtime workbook that list the dates (Column B) and hours of overtime worked (Column E) by employee number (Column A)...
  11. B

    Calculate Overtime with multiple criteria

    I am trying to make a timesheet that calculates overtime with the following criteria... 1. Overtime is after 8hrs on any given day. 2. Overtime is after 40hrs/week...consideration to the after 8hr criteria to ensure not duplicating overtime. 3. The after 40hrs/week overtime criteria changes if...
  12. B

    Calculate dates and times for regular time & overtime ...and also consider weekends and holidays

    Subtract dates and times for overtime ...and also consider weekends and holidays PLEASE PLEASE HELP I need help with a formula to deduct ie dates and times to calculate regular time and overtime and multiply the regular time with the basic salary of R18.75 (Rand)....and Saturdays with...
  13. D

    Include a Dropdown List in a Conditional Statement

    Hey guys, Here is an example/breakdown of what I am trying to do. If C1 says Overtime, then I want D1 to display a dropdown list of the codes in (A1:A4). If C1 is blank, then I want D1 to be blank as well. <tbody> A B C D E 1 CodeA Overtime 2 CodeB 3 CodeC 4 CodeD...
  14. P

    Formula Based Scoring Time Between Two Dates

    Hello all. My work is instituting an incentive plan to encourage overtime when needed. They decided on a point system where you earn points for each hour you work of overtime. Each hour of each day may be worth a different point. As an example: Working 6:00 PM - 7:00 PM on Tuesday would be 1...
  15. R

    Sum up to certain value ???

    Hi there, it's been a while since had such a hard time figuring out what I need to do with certain formulas. My question is this. I have a sheet with days and the overtime that is worked on those days. The overtime is split up in 4 categories. OT, DT, PPH, PPH OT. Now the target for the...
  16. L

    calculating overtime idea

    Hi I want to write a formula to calculate overtime. If the total hrs worked is more than 8 then that is overtime I thought abut this formula but did not work. It only work if the difference is 1hrs and above. if it is 1/2hr then I get garbage number. = max(A1-8,0) <tbody> total hrs worked...
  17. J

    SUMIF or maybe SUMPRODUCT

    Hi all, I have an overtime spreadsheet that calculates the cost and productivity of the overtime hours per salesperson, per month. Up until now the overtime rate has been 1.5 which was easy to calculate using SUMIF using month and then the ‘hours worked’ column to calculate. I use this...
  18. A

    timesheet formulas

    Hi All, Would someone be able to help me in designing a timesheet in excel, I do not know how to do the formulas for all the rules below. I guess to have seperate columns that splits the hours worked into the following categories and seperate columns for the rules? I appreciate this is a lot...
  19. P

    Time difference formula on 24hr clocks over midnight

    Hi Guys, Been stuck on this one for a while. Need to figure out some turnaround times for overtime (while filming we get overtime for however much we break an 11hr turnaround). So times are logged in 24 hr format, so I need to work out some time differences but having a huge amount of trouble...
  20. W

    SumIf and Sum by color

    Any help in this would be greatly appreciated, I am setting up an Overtime Equalization Spread sheet that tracks numerous pieces of data throughout the fiscal year. I. E. If employee worked overtime , if they refused overtime, what shift I was for ( Day Afternoon or Nights) and the reason...

Watch MrExcel Video

This Week's Hot Topics

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
Top