I work for a global company and I’ve been asked to add some information to a directory.
The current file shows Name, Region, Country, Office, Phone Number, etc.
I’ve been asked to add in the time difference between that person and us (either current user or just Eastern US time), and then the timeframe in Eastern US that would be ok to call the person on the list (to help coordinate conference calls, so like 8am-6pm for everyone).
I’ve gathered the GMT for each of the people (US, Latin America, Europe and Asia) and whether or not they participate in any kind of Daylight Savings Time. Unfortunately, this is all complicated by the fact that not each country participates and not at the same time (Europe is different from US, then Southern Hemisphere is different, and Brazil is also different). Plus the dates are usually “Last Sunday in March” kind of thing, so it changes from year to year.
I’m having trouble figuring out the best way to organize all this information. First, is there a way to get Excel to spit out the date for “Last Sunday in March”? Any thoughts on how to best organize this? I don’t know if it will be distributed to the people on the list, or just used by the “organizers” of the team. Any other thoughts on the project?
Many thanks.
Eve