hi guys,
this is my cell (O11) to calculate straight time hours. Cell N11 is the total number of hours worked. The cells they log in and out are f11 time in, G11 : time out, H11 : time in, I11 : time out, J11 : time in, K11 : time out, L11 : Time in, M11: time out = :=SUM(IF(G11<F11,G11+1,G11)-F11,IF(I11<H11,I11+1,I11)-H11,IF(K11<J11,K11+1,K11)-J11,IF(M11<L11,M11+1,M11)-L11)*24 which calculates total hours in cell N11.
If they work between the hours of 12 am and 6 am, how to i make :
Straight time hours =IF(N11<>0,IF(MIN(SUM(N11),8)<5,5,MIN(SUM(N11),8)),0)
Minus those hours between 12 am and 6 am
and add them to cell (q11)=IF((N11-O11-P11)<0,0,(N11-O11-P11)) which is double time hours worked
thank you for any help you can give me.
Hope this isn't too hard to follow.
Dann
Bookmarks