Hi Sean,

I know it's confusing, I will attempt to explain this as detailed as possible, so on daily basis up to 8 hours are going into REG hours bucket, any hours over 8 goes into Daily OT bucket, when 40 hours are deposited in REG bucket then the Daily OT bucket is ignored and all hours after that goes into Weekly OT bucket, so on 04/11/2014 even though this employee worked 9 hours but because the first 8 hours on that day filled the REG bucket all the way to 40 hours the 9th hour or anything beyond that need to go into Weekly OT bucket.

The hours are broken down as follows, I added running totals columns just to explain the progress, I hope this makes sense.

Thank you,

PERSON DATE ACTUAL_HRS REG_HRS_RT DLY_OT WKLY_OT DLY_OT_RT WKLY_OT_RT

-- First Week --

123403/31/2014 8.00 8.00 0.00 0.00 0.00 0.00

123404/01/2014 9.00 16.001.00 0.00 1.00 0.00

123404/02/2014 8.00 24.000.00 0.00 1.00 0.00

123404/03/2014 8.00 32.000.00 0.00 1.00 0.00

123404/04/2014 9.00 40.000.00 1.00 1.00 1.00

-- Second Week --

123404/07/2014 10.00 8.00 2.00 0.00 2.00 0.00

123404/08/2014 8.00 16.000.00 0.00 2.00 0.00

123404/09/2014 8.00 24.000.00 0.00 2.00 0.00

123404/10/2014 9.00 32.001.00 0.00 3.00 0.00

123404/11/2014 9.00 40.000.00 1.00 3.00 1.00