overtime

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

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!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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