Calculating OT in Excel

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

Thank you for the formula. It does not exactly calculate how I need it to. I need the formula to calculate OT hours for anything over 40 hours in a week, but over 48 hours in a week if an employee takes 8 hours for a vacation day, sick day or if it is a holiday during that week.

I tried that formula, but that will not calculate any ot. The formula I have in I10 is currently =MAX(H10-40,0) which will calculate the OT on a regular week where no vacation, sick or holiday time is used and it calculates correctly. The issue I am having is when an employee takes 8 hours of vacation, sick or holiday time, I also need the formula then to calculate the OT hours when they go over 48 hours for that week.

Ok, now that makes sense. Is there a way for the value in cell I9 to be zero when a value is entered in cells L,M,N 5-9? I don't want the employee to think they are going to get 6 hours of OT when in fact they would get 0 for that week! Thanks again for your help!