I've just just stumbled across this and it's almost exactly what I am having a problem with.

I am using the same formula to deduct a 30 min break from any shift that is over 6 hours but it seems that as I have used the hh:mm cell format I can't subtract the break.

Code:
=IF(E4>6,E4-0.5,E4)
, E4 being the total hours worked but in hh:mm format.

If I try it with decimal value's it works fine but could anyone...