if E1:E12 (each) cell is equal to more than 9.5, I need L12 to equal the
cells minus 9.5 - i'm trying to get my worksheet to calculate overtime hours
for our employees

for example E1 is 10.5, E2 is 9.5 , E3 is 10...I need L12 to show 1.5 in
overtime hours. I'm not sure is excel can calculate this way, but if it can
I would surely appreciate any input!