I have this list with all the American Airports. I'm using it to find weather code stations, but I'm wondering if I can take it a step further and figure out what timezone each airport belongs to.

Not sure where or how to start.

I could calculate an operation with imaginary boundaries, or I could maybe just find an easier way to type in every single timezone without having to do it manually and find the states that have 2 timezones...

This is an image of the table I have. On it highlighted it's the formula.

This is the formula I am using:

=INDEX($H$2:$H$3417,MATCH(MIN(($K$2:$K$3417-L4)^2 ($J$2:$J$3417-M4)^2),($K$2:$K$3417-L4)^2 ($J$2:$J$3417-M4)^2,0))

The idea was basically using square root to find the proximity of coordinates.

a2 b2 =c2

This is a previous post I made on this and why the formula it works the way it works.

What would be the smartest way to start building a timezone stamp...? is it even possible...?

Thanks!