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