Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
whitestonek
Contributor II
Contributor II

How to calculate travelling time Duration from one country to another country

I have one table with Columns like FROM DATE, TO DATE WITH TIME duration, COUNTRIES, STOCKS FIELDS.So, Flight moved from India to China on the particular date. Here I want to calculate travel duration with GMT. How to implement this in set analysis.Please suggest ASAP.

1 Reply
wade12
Partner - Creator II
Partner - Creator II

convert local departure time to GMT,

convert local arrival time to GMT,

duration = arrival GMT - departure GMT.

best wishes.