I created a timesheet whereby the tech puts his hours in a cell and the formulas figure out overtime and bank time. For instance
=0+IF(B12=8,B12-8,IF(B12=8.5,0.5,IF(B12=9,1,IF(B12=9.5,1.5,IF(B12=10,2,IF(B12=10.5,2.5,IF(B12>=11,3,)))))))
The problem is, I am only allowed 7 IF's in a formula...