World clock excel

[enfantter]

Because your the smartest guys i know on the web

Does anybody know whether it is possible to show the current time in other time zones in excel.

That is automatically without saying fx UK time +10 for australian time if i am in the UK.

/enfant terrible

[Bob Phillips]

How do you want to run it? Do you want a list of countries/cities/time zones, and get the time for that? What about DST?

[enfantter]

I was hoping that i could somewhat pull this straight from excel.

Like, I can get the current time in my time zone, hoped i could pull the time from fx autralia.

The reason for this is that i want to make my sheet robust to DST

[Bob Phillips]

Australia has multiple time zones! You didn't answer my question.

[enfantter]

Sorry - Sydney

Yes i have a column where all the country names are - ideally i would like to show the current time for each of the countries/cities

[Paul_Hossler]

Add the GMT adjustment for each city/country in a new column and use your current time and your own GMT adjustment to calculate the current time in the other cities

Paul

[enfantter]

I realize this could be a solution but it would be highly manual as I would need to adjust for DST twice a year - every year, I guess all summer time is not synchronized with London ... ??