Input: Time Zone. Output: Current Time

Hey guys!

I'm looking to have one column where I input the time zone (EST, GMT, PST, etc...) and another column outputs the current time.

Ex: It's currently 12:00 PM PST.
Column A- I type in EST
Column B- Outputs 3:00 PM

Appreciate any feedback!

Subtract/add the appropriate time difference

e.g

A1-TIME(5,0,0) if time zone is 5 hours different

If you have several time zones to consider then it might worth setting up a table with Time Zones e.g EST and Difference (5)

Good enough for me. Thanks!