I have a formula that is subtracting time and when the person works more than
4.99 hours it is automatically taking .5 out for the lunch break. Well the
formula is working for the most part however it appears not to work when the
start time is on the hour it bring back an incorrect value.

Formula:

=MOD(K20-K19,1)-IF(MOD(K20-K19,1)4.99/24,0.5/24,0)

The incorrect value:

9:00
14:50

Answer: 5:20

I anyone can help let me know. Thanks!