Forum Discussion

TaraStroup's avatar
TaraStroup
Qrew Member
5 years ago

Need to calculate the duration of a flight taking time zones into consideration

Hello, 

Does anyone have a suggestion of how to calculate the duration of a flight with timezones as a part of the equation? 

Thanks, 
Tara

------------------------------
Tara Stroup
------------------------------
Formulas and functions
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Do you have a table of all the possible time zones and their offsets from say GMT?  The rime zone codes would also need to know about Day Light saving time.

    You would look up the offset from GMT  for both the DEP and the ARR flight.  So Key field of he time zone table would be the Time Zone code like
    EDT
    EST
    CDT
    CST along with their offset, Then look up those offsets into your flights table with two relationships and do the math on adjustments.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------