+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Excel timezone conversion (/Thread-Excel-timezone-conversion)
Excel timezone conversion - wsadmin - 07-24-2008
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