hello, everyone, is there any IF statement that i can use on below time range when counting start/end time and return correct or out of range?
<tbody>
</tbody>
thanks in advance
request time | given time | return |
09:00-18:30 | 09:00-18:00 | correct |
09:00-16:30 | 09:00-19:00 | out of range |
13:00-21:00 | 12:00-21:00 | out of range |
<tbody>
</tbody>
thanks in advance