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

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History