Select timezone for each record

Hello,
I’ve got a table set up which is to hold flight data. So I have airport from, to and date/time fields. I would like to have the timezone listed in the time field as it is always local to the origin or destination. Is this possible? When I select show timezone it appears at GMT automatcially but I can’t then change it.

Thanks

Welcome to the community, @Nat8100!

This is very tricky in Airtable because the timezone would need to be in another field, but you can get the results you’re looking for.

Check out my sample time zone base & its accompanying training video. It’s pretty complex, so take some time to digest it all:

1 Like

Thanks for your reply. I’ve downloaded your table so will see if I can make something work with that.