OK, So heres my problem I was wondering if anyone could possibly help. I seem to have hit a brick wall while calculating double time in my time sheet. I need the regular hours to be no greater than 8, I need the overtime hours to be no greater than 4 and the double time hours to be anything over 12. I think the problem lies with the way the overtime is calculated in my sheet to begin with. When someone works 8 hours everything displays fine (as with example one in the time-sheet) When someone works more than 8 hours the remainder is automatically thrown into the overtime cell (as with example two in the time sheet) So for instance if someone worked 14 hours with a lunch I cant figure out the formula to get the overtime cell to display four hours and the double time to display 2 (8 regular, 4 overtime, 2 double time = 14) If anyone could help me it would be greatly appreciated.Oh and I have i have attached the time-sheet (2007 excel) so anyone that can see what i did wrong can get an idea of what I'm talking about. Thank You in advance.
Bookmarks