If total hours is displayed in column C for employees in row 3 through
30, put the formula (or add to the present formula) in cell C3
+SUM(B3:J3). Copy the formula through cell C30. Now the first day put
the overtime hours in column D, column E for the next day's OT hours,
column F for the next day's hours, etc You can even name the columns D
through J Monday, Tues, OT hours. To start the next week, just
delete tehe contents of column D through J. ed