Hello Matt,

In cells B10 and D10 you don't have valid times, for excel at least, if you enter those times with a colon between hours and minutes like 12:00 and 20:30 then you can use this formula to calculate the total hours and deduct half an hour if over 6

=(D10-B10)*24-IF((D10-B10)*24>6,0.5)