WEBSERVICE for City Times?

[RatHat]

Hi All,

Does anyone know a webservice URL for finding times in a city of location?

For example if I had London writtem in cell A1 and I wanted to use =WEBSERVICE("URL/"&A1) is there a URL that will allow me to do this?

[MarvinP]

Hi RatHat,

See if this might do what you need:
https://www.timeanddate.com/worldclock/?query=london
See if you can replace the last word with the city you want.

[RatHat]

Hi MarvinP,

I tried it but just get errors with the url. Tried all sorts of combinations to try and get it to work, but theres a problem with Excel reading the link, and I cannot figure what it needs.

[AliGW]

So, what exactly did you try?

There are instructions at the top of the page explaining how to attach your sample workbook.