check if specific time falls between multiple parameters

[lamarh]

Our app allows teachers to request art lessons from a volunteer art program. The lessons are varying lengths and teachers can request a specific start time. I have a calculated field that gives me the end time based on the lesson length and requested start time. I need to check if the  calculated field falls between recess start/recess end, lunch start/lunch end or after school end. Can anyone help?

[NiceDuck]

If the time values for the recess start/recess end, lunch start/lunch end or after school end is static, you can try using another calculated field to check that for you by using a case statement and datepart function. 

Use the datepart to get the specific time values of the time you have from your original field. You should have an integer result from that which you can directly compare to the to your other  ecess start/recess end, lunch start/lunch end or after school end value.

[ParkLoey]

A nice suggestion coming from @NiceDuck   Dropping the function reference article here in case you need reference for using datepart: https://howto.caspio.com/function-reference/

[lamarh]

Thanks for the help!  I used another calculated field to check if the start time was before the end of recess/lunch AND if the end time was after the start of recess/lunch. If both are true, then the field returns a value ('lesson overlaps with recess', '... lunch'). Then I used javascript to prevent form submission if the value equals anything except 'ok to schedule' and also display an alert box with the value.