1. J

    VBA or Excel – Time sheet with RT / OT based on the day of the week.

    I need help with VBA Code or an Excel formula. PURPOSE: I need to auto calculate OT based on the days of the week (Saturday & Sunday). For Monday – Friday any hours as follows: [**This part of the sheet works fine] Cell Range = F15,P15:F50,P50 In Cell Q15 formula: =IF(S15<8,S15,8) In Cell...
  2. T

    Regular, Overtime and Double time between midnight and 6 am. The back to regular time after 6 am. Over 2 days.

    I am trying to create a time sheet that calculates regular time up to 8 hours, overtime after that and double time between midnight and 6 am. After 6 am the time returns to regular time. Also double time happens after 12 total hours of work Any help would be appreciated!
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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 -...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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)...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. J


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

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