Challenge #368: Time Zones

[ZachBowders]

Good times

[Laurap1228]

This was fun! 

Spoiler

Spoiler

[nli]

My solution. 

Spoiler

Wondering if there's a different way to do a self-join...

[alfredcsy]

[MattBenj]

My solution

[Rob-Silk]

Solution attached below:

Spoiler

[snbandi]

My solution

[asultanov]

Spoiler

Formula tool actions
1a. Get rid of that pesky minus sign for a regular dash
1b. Convert offset to number
2a. Make city pair
2b. Get time difference
2c. Make "ahead of/behind" variable
2d. Get absolute value of difference
2e. Construct sentence

[Bren_Spill]

Spoiler

 

[Andrew_D]

Solution:

Spoiler