I have set up a time sheet for employees to fill out on the computer. I need
one column (STRAIGHT TIME) to total up to 8 hours ONLY, and anything beyond
that to go in the OVERTIME column. So in other words, if I work 10 hours in a
day, I need Excel to automatically record 8 hours in the straight time
column, and 2 hours in the overtime column. I can't find what formulas to use
to make this happen automatically upon entering the hours worked.