Time Zone Conversion

[AndyB63UK]

I have a spreadsheet for the weekly times of Zoom meetings with 3 tabs. Tab 1 is for the user, Tab 2 is for the Host, Tab 3 is a list of Time Zones as pictured

The Host selects their timezone by there name in Host!B? (there can be several from different countries), but when the user enters their time zone in User!A3, the host time are displayed in local time

I've currently set User!A3 and Host!B3:B17 as dropdown lists from Timezones!D2:D79 but not sure if this is right.

Many thanks in advance

 

[jasonb75]

All times will be displayed using local time as a base, you can't change that without changing the time zone on the system clock.

To manipulate it with formulas, I think that the logic should be something like below, but I'm getting serious brainfart trying to evaluate it mentally.

Host time =NOW()-User+Host
User =NOW()-Host+User

Where Host and User refer to the difference between local time and UTC for the Host and User respectively.