Timezone Conversion help

[elitef]

Looking to see if I can get some help with timezone conversions in excel via formula of some sort (or VBA)

So, I have a spreadsheet with a few fields, one of which is a time/date fields where I enter my local time example 14:30 and 03/31/2022
I have a list of timezones from which I can select (example: EDT, EST, CDT, CST, CET, CEST, etc) from a drop down to select MY timezone that I am currently in for which the above time/date is accurate for.

I am looking for a formula to convert the time/date in A1/B1 to the GMT equivalent of the same time in C1/D1.
I would like for it to account for the DST for certain timezones (ex EST vs EDT)

 

[Sulprobil]

Julian Hess and Patrick Honorez have suggested a very good time conversion program for MS Access as well as for MS Excel to convert a date and time from one time zone into an other one. Please note that this solution requires MS Outlook to be installed properly:
Get Timezone Information in VBA (Excel)