This is a classic payroll thing.

I two columns of names.

Coloumn L has a list of all names on the payroll.

Column D has a list of the same names, but mutliple times. Column E lists
the week. Column F lists each employees weekly hours.

Column O, I want to calcualte the total amount of hours upto 40 per week.

Column Q I want to total all hours that are over over 40.

Ex. John Smiths weekly hours
F13= 43
F14= 38
F15= 45
F16= 25

O14 = 143
Q14 = 8