I have a table with flight arrival/departure airports and time stamps in local time

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

I have a table with flight arrival/departure airports and time stamps in local time - is there a way to convert the time into one time zone?

Post Flair (click to view more posts with a particular flair)

unsolved

Post Body

Pretty much the title really - I have a table with thousands of flight records for which I have arrival and departure locations and also arrival and departure times. The issue is that I am looking to calculate the duration of these flights so I need all of the arrival and departure times to be converted into one time zone (preferably Eastern time but can work with any time zone really) - is there a way I can do that?

I'm pretty sure there isn't one that doesn't involve hours and hours of work but I figured I'd ask anyway.

Thanks!

Author

Account Strength

50%

Account Age

8 years

Verified Email

Verified Flair

Total Karma

103

Link Karma

Comment Karma

Profile updated: 6 days ago

Posts updated: 11 months ago

exceltata

Subreddit

r/excel

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 4 years ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/excel/comme...