Hello,
I am trying to to a simple formula to do this.
on sheet one i have 3 colums timezone and time and time2, on sheet 2 i have a table with the value of the timezones ex: timezone france 1h timezone germany 2h and so on, what i an strugling to do is a simple formula that if timezone is france it subtracts the the value of that timezone from time and shows that value on time2.

ex:
Timezone | Time | Time2
France | 12:00 | 11:00
germany | 12:00 | 10:00