Convert time from one time zone to local time.

Hello, I need some help. I have a attached a sample of what I need help with. I have a list of meetings located in different states. I live in AZ and I find myself looking up the time zone conversion quite often. I am looking for a way to automate the process.

I have attached a list with the meeting times in column B and the State in column E and county in column D if needed. I would like to automatically fill-in the AZ time equivalent which is in column C.


I found a good list of the states with their corresponding time zones. I have attached that as a sheet named "TimeZones".

My first thought was a V-lookup but I can't figure out how to make that work. I would prefer a macro that can do it all but anything that works and is efficient would be great. Thanks!