I have a spreadsheet that calulates the Overtime & Double Overtime on a daily input basis. However, the formulas are incorrect and I cannot seem to get them to work correctly. Please help!!!
Standard Time = 0-8 hours
Overtime = 8-12 hours
Double Overtime = 12-24hrs
Right now, the spreadsheet calculates the time as follows:
Standard Time = 0-8 hours
Overtime = 8-16 hours
Double Overtime = 16-24hrs
Last edited by KimBVS; 08-24-2011 at 01:31 PM.
I'm not sure if I'm reading this right or not, but I tried a SUMIF based on the value of column A looking for OT, DOT and DT.
Try putting...In cell I22
Please Login or Register to view this content.
In cell I23Please Login or Register to view this content.
...finally, in I24Please Login or Register to view this content.
This returns:
Please Login or Register to view this content.
Thanks for the help but it doesn't calculate. Perhaps I did not explain well enough. I want the total hours split (regarless of code) to reflect the following:
Example 1:
19 hours- total
8 hours - regular (time less than or = to 8 hours)
4 hours - overtime (time greater than 8 hours but less than 12 hours)
7 hours -double overtime (time over 12 hours in a 24 hour period)
Example 2:
12 hours- total
8 hours - regular (time less than or = to 8 hours)
4 hours - overtime (time greater than 8 hours but less than 12 hours)
0 hours -double overtime (time over 12 hours in a 24 hour period)
Example 3:
23 hours- total
8 hours - regular (time less than or = to 8 hours)
4 hours - overtime (time greater than 8 hours but less than 12 hours)
11 hours -double overtime (time over 12 hours in a 24 hour period)
Hope this helps
OK, I think I may have it. The Overtime was the tricky one, because if the Time isn't between 8 and 12, you still want to return a number of overtime hours if Time is greater than 12.
For the following I have used D4 as the cell with Time in it, and these 3 formula are in cells D6, D7 and D8:
Please Login or Register to view this content.
That works perfect. Thanks so much!
Re: Overtime & Double Overtime - IF function
Hello, I need the same formulas as you were needing:
I want the total hours split (regarless of code) to reflect the following:
Example 1:
19 hours- total
8 hours - regular (time less than or = to 8 hours)
4 hours - overtime (time greater than 8 hours but less than 12 hours)
7 hours -double overtime (time over 12 hours in a 24 hour period)
Example 2:
12 hours- total
8 hours - regular (time less than or = to 8 hours)
4 hours - overtime (time greater than 8 hours but less than 12 hours)
0 hours -double overtime (time over 12 hours in a 24 hour period)
Example 3:
23 hours- total
8 hours - regular (time less than or = to 8 hours)
4 hours - overtime (time greater than 8 hours but less than 12 hours)
11 hours -double overtime (time over 12 hours in a 24 hour period)
Please help. Thank you. (When I try to pull up the answer, it doesn't show it)
CNTRYSMLS,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Blank Timesheet_2.xls
take a look at this one.
sorry i miss #5
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks