Hello all,
I am try to compose a spreadsheet where i am coverting different timezonesfrom around the world to local time to local time.
What i have actually done is download web queries for different time zones Eg Frankfurt which is one hour ahead of BST (british summer time).
What im trying to do by having a formula that can convert my web query time EG 18:00 CEST - the time difference 1 hour and then have it reflect the local time. So If a shop opens at 9am CEST i want it to reflect at 8am BST that the shop in frankfurt is open
I know its confusing but any advice would help
I am try to compose a spreadsheet where i am coverting different timezonesfrom around the world to local time to local time.
What i have actually done is download web queries for different time zones Eg Frankfurt which is one hour ahead of BST (british summer time).
What im trying to do by having a formula that can convert my web query time EG 18:00 CEST - the time difference 1 hour and then have it reflect the local time. So If a shop opens at 9am CEST i want it to reflect at 8am BST that the shop in frankfurt is open
I know its confusing but any advice would help