Hi Jesse,

You need to multiply the time by 24 to turn it into a decimal.

e.g. Total Time Worked + OT =(SUM(H10:H23)+K24)*24

7:40 becomes 7.67

Make sure you format the cells to number with 2dp.

HTH - David