Get order by from two columns based on time

 Hi

I am having a table with two columns that is Arrival and departure times i need to get the out put based on time from two columns  in ascending order 

   

 

ArrivalDept Table

Pkey  Fkey_Sno   Arrival    Departure 

 

1          1                  00:00      12  :00

2           2                 10:40       11:10

3            3                11:05       11:15 

4             4               00:00         11:30

 

 

need Final output as 

 

 Select Pkey ,ArrivingTime,DepartureTime from table1  where Arrival between '11' and '13' or Departure  between '11' and '13' order by Arrival  it gives out put as

 

 1        1       00:00        12 :00

4         4       00:00        11:12 

 Any suggestions will be helpful