1
What you seek is a table like the one below,
from which you could query:
SELECT *
FROM departures
WHERE route_id = 'SOME_ROUTE' -- This is the code to a route, encompassing from/where
AND departure_date = @some_day
AND departure_time_min <= @target_time
AND departure_time_max >= @t...