@TimOH2390
I have only managed to write very easy VBA code to calculate overtime for each pay period. I entered table in range A1:B15. Enter pay period number in D1 and execute macro and overtime for the chosen pay period is displayed in D2.
Sub Overtime()
Dim i As Integer
Dim z As Integer
Dim j As Double
z = 0
For i = 2 To 15
If Cells(i, 1).Value = Cells(1, 4).Value And Cells(i, 2).Value > 10 Then
z = z + 1
If z >= 2 Then
j = j + Cells(i, 2).Value - 10
Else
End If
Else
End If
Next i
Cells(2, 4).Value = j
End Sub
