# if or statements

July 30, 2011 at 10:38:45
Specs: Windows 7
 Making a sheet to keep track of my hours workedThe cutoff is different than total hours in a week (Monday to Sunday). Entering 13 hours is comprised of 8 regular, 4 time and a half, and 1 double time (less 1/2 for lunch). Thur should have 1 hour regular time and 11 hours time and a half. Any ideas?Mon 13 8 4 0.5Tue 13 8 4 0.5Wen 13 8 4 0.5Thu 13 8 4 0.5

See More: if or statements

#1
July 30, 2011 at 13:13:39
 re: "Thur should have 1 hour regular time and 11 hours time and a half"Please explain that. Thursday says 13 hours, which according to your post should be: 8 + (4*1.5) + (1*2) - .5 = 15.51 hour regular time and 11 hours time and a half is:1 + (11*1.5) = 17.5Why isn't Thursday 15.5?I think this is what you are looking for, although your "Thur" statement has me confused.=(IF(A1<=8 ,A1 ,IF(A1<=12, 8+(A1-8)*1.5, 14+(A1-12)*2))) -0.5Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

#2
July 30, 2011 at 13:37:21
 Derby Dad03Your right! Not only have I confused you but myself as well. It seems to be wide problem when you are paid overtime after eight and over 40 in a week. I am trying to come up with a way that would figure out the overtime hours after 40. Thursday would be over 40 hours. Hence I hour should be returned in the regular hours and 11 in the time and a half column. I could not find a template that deals with both compensations.

Report •

#3
July 30, 2011 at 16:57:48
 Your original post did not say anything about "over 40 hours". The only thing you mentioned was the breakdown of a 13 hour day (8, 4 & 1) therefore I provided a formula that handles that situation.I still don't understand how you can have 8, 4 & 1 for some 13 hour days but the 13 hour day on Thursday is broken down into 1 & 11.I also don't quite understand how the .5 ends up in the 3rd column. If you have to subtract a 1/2 hour for lunch, does it always come out of the double time hours?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions