View Full Version : World clock excel
enfantter
10-17-2011, 02:30 AM
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
10-17-2011, 04:28 AM
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
10-17-2011, 04:57 AM
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
10-17-2011, 05:21 AM
Australia has multiple time zones! You didn't answer my question.
enfantter
10-17-2011, 08:19 AM
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
10-17-2011, 11:33 AM
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
10-18-2011, 05:05 AM
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 ... ??
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.