I have made a calculation for my work here I need to know if I have a break or not.

The if function should look or between the start time and end time is 4 hours.

If the result is less or equal than 4 hours I need to get a value of 0:00, if it is more than 4 hours then I get the result 0:30. (result must be as a timestamp)

In mine If function I let in this case:

time of 15:00 subtracting 8:00 then passes the test if the value true when it must be false, the formula I7 (15:00) minus H7 (08:00) <= 4 is natural result than 7 false;

Value as well which is 0:00

Value - if - false than 0:30

Hope some one can solve my problem?

Thanks for help