Departure_Time at source is 18:25
and Arrival_Time at destination is 05:20
so
tt2.Arrival_Time -tt1.Departure_Time As Travel_Time
gives -130500
instead 10:55H
how to achive this? any help will be appretiated..many thanks.!!
edit- destination time is of second day..
I wrote a code for you that you can modify the difference of days between departure and arrival.But but but this code is only and only for a single time zone.If you have different times in different time zones that's different!
And I really don't have any ideas why did I use i:s for hour and minute!
But anyway it works!
Tell me if you have any problem with the code :)