Frequent Visitor

# Overtime Calculation Values

I have a time sheet that uses rows for job names and each column is a day of the week running Wednesday thru Tuesday. At the bottom of the sheet (C40:I40) is straight time (no overtime). Straight is calculated =IF(SUM(C9:C39)>8,8,SUM(C9:C39)), only allowing a maximum of 8 hours to be posted in the cells calculation. Time and a half is calculated in the next row (41) as =IF(AND(SUM(C9:C39)<>8,SUM(C9:C39)<12),SUM(C9:C39)-8,4). Row 42 (double time) is calculated as =IF(SUM(C9:C39)>12,SUM(C9:C39)-12,0). Each row is totaled in column J40 thru J42 respectively.

My problem is that the calculations from row 41 are not being totaled in Column J as expected. Essentially what I'm trying to do is, anything over 8, but less than 12 in one day is time and a half. So, time and a half maxes out at 4 on week days. Saturday's are time and a half until 8 hours. After that it's double time. Sunday is all double time. Anything over 12 hours is double time in row 42.

Why isn't time and a half being totaled? I assumed it had to be something to do with the ADD function, but I can't figure a way around it. Can someone help with this? My worksheet is attached.

``=MAX(0,MIN(SUM(C9:C39)-8,4))``