'How do I use importxml formula in google sheet to get data from timeanddate.com?
I want to get UTC difference of each timezone in google sheet. For that, I am looking to import data from timeanddate.com using importxml. But, it says URL not found.
Example for Asia/Jordan: My formula is =importxml("https://www.timeanddate.com/time/zone/jordan","/html/body/div[6]/main/article/section[1]/div[2]/table/tbody/tr[3]/td")
The timezone is in IANA format like Asia/Jordan.
Any kind of help will be highly appreciated. I really need help. Please help.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|