Two possible formulas to use in column I, starting at row 3 a

=IF(C3="Y",0,IF(D3$E$24,0,MIN(H3,8)))
handles the case where ONLY shifts starting after 5:00 PM (in $E$24) get
time-and-a-half rate, and
=IF(C3="Y",0,IF(OR(D3<$E$23,D3$E$24),0,MIN(H3,8)) )
which handles situation where shift starting before 8:00 AM (in $E$23) also
gets overtime rate.

Question remaining seems to be if a shift starts before 8:00 AM, do they get
1.5 overtime rate for the entire shift, or just until 8:00 AM rolls around?

Working on a solution for that while waiting for the answer that I'm pretty
sure is going to come: only pay 1.5x rate until 8:00 AM



"Oldjay" wrote:

Thanks JLatham for the reply but I was looking for a solution before you get
back on Oct 8
Can anybody else look at my problem?

oldjay

"Oldjay" wrote:

I have a time sheet form that calculates regular time,over time and holiday
time. I can't seem to get the formulas correct.
Would anyone look at it and give me some advice?
It is only 17K
I tried to copy it to this message but it was very confusing

oldjay