Challenge #368: Time Zones

[Jean-Balteryx]

Here is my solution !

[Bobbyt23]

Good fun working out the differences in timezones.

[aatalai]

C368

[TobiasFitschen]

Spoiler

 

[josh_salto]

 i enjoyed this one. but it i can find ways to optimize this.

[Supriya2203]

• Use text to column tool to break the codes( to rows)
• use formula to convert time to int before appending to reduce effort:
• if left([UTC_offset_STD],1)="−" then -1*tonumber(Replace([UTC_offset_STD], "−", ""))
  else ToNumber([UTC_offset_STD])
  endif

[lwolfie]

REGEX was not my friend today so I went a different route.

[cmoussa]

[JBevan89]

Solution Attached.  Love this challenge