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

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.

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.

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.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History