excel - How to convert timezones in google sheets

Question

So I have a sheet with two columns Time Zone and Time . I want to convert all these times to EST in a new column. Is there a way I can do this either with scripts app or native sheets formula?

Image of Sheet

Answer 1

等待大神解答