if or statements

July 30, 2011 at 10:38:45
Specs: Windows 7
Making a sheet to keep track of my hours worked

The 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.5
Tue 13 8 4 0.5
Wen 13 8 4 0.5
Thu 13 8 4 0.5


See More: if or statements

Report •

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

1 hour regular time and 11 hours time and a half is:

1 + (11*1.5) = 17.5

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

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
July 30, 2011 at 13:37:21
Derby Dad03

Your 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


Ask Question