I need a little help with calculating OT in Excel. I have the formula correct to calculate OT for hours worked over 40 hours in a week, but I am at a loss as to how to calculate OT for the week when the employee takes a sick day, vacation day or there is a holiday in that week (columns L,M,N) as those hours do not count towards OT and the OT would start after the employee hits the 48 hour mark. Columns J and K do not factor into any of the calculations, it is just a info field.

I have attached the file I am working with. Any help would be greatly appreciated!

Time Card.xlsx