Challenge #368: Time Zones

[CasperBuenting]

Spoiler

A somewhat "unique" solution... but it works

[dYoast]

The hard part was getting the UTC offsets converted to integers.  Finally found a way.

Spoiler

[sylviayang]

Finding my solutions a little bit daunting. I will try to use Regex to parse the time

---

Spoiler

[jagdeep_singh85]

PFA my solution

[VladimirR]

My solution:

Spoiler

[Keyly]

Here is my solution:

Spoiler

Key Point:
1. Split Column to Row for [country_code]
2. Split City from [TZ_database_name]
3. Clean [UTC_ofset_STD] and convert to number for calculation the time diff

[FilipR]

Solved.

Spoiler

[elena_mazareanu]

Solved

[Shifty]

Time ticked away on this one. ⏲

Spoiler

[bkclaw113]

I did complete in Designer Cloud, but still do not find it as intuitive as Designer. Guess practice is what is needed. Also the solution here is a little sloppy since it would not work for half hour differences like you get in India.

Spoiler