I need the formula that will allow me to subtract a 1/2hr lunch if an hour
result is equal to or greater than 8.5 hours.

A B C D E
Start Time End Time OT Hours Total worked hours
7:00 15:30 8:30 8.0

This is an example of what my answer should be.

I have tried so many formulas that I thought should work but it doesn't
carry over to other rows. =SUM(D5I4, D5-I3) I4=0.333333 and I3=0.02083333

My brain is mush so I am hoping one of you could help.