Solved

Time Zone Descriptor clean-up needed

Posted on 2011-03-19
8
363 Views
Last Modified: 2012-05-11
I am looking to clean up the time zone descriptors listed in the "Choose Your Time Zone" column here >> https://spreadsheets.google.com/ccc?key=0ApGg6c9aeywQdGZ5VzcxZHljZkJjQmJ5Y2hJMFgzYUE&hl=en

They should represent the offset first, then the actual name of the time zone, then the location.  What is missing is the actual name of the time zone in many cases.  Thanks you guys very much for all the help thus far on this >> https://spreadsheets.google.com/ccc?key=0ApGg6c9aeywQdGZ5VzcxZHljZkJjQmJ5Y2hJMFgzYUE&hl=en
0
Comment
Question by:rtod2
  • 4
  • 4
8 Comments
 
LVL 18

Expert Comment

by:Curt Lindstrom
ID: 35174330
You change the names in the description table to anything you like yourself. It requires nothing technical assistance.

Curt
0
 
LVL 18

Expert Comment

by:Curt Lindstrom
ID: 35174337
You can also add new time zones like +9.30 in Adelaide as long as you add both descriptor and time zone. In this example it would be something like Description = Adelaide + 9:30 and Time Zone =   9.5

What you cannot do is to add more than one row for the same time zone. So if you want more place for a time zone you need to add it in the same cell

Curt
0
 
LVL 18

Expert Comment

by:Curt Lindstrom
ID: 35174342
Sorry I lied then, you can actually add more than one row for the same time zone. The lookup is on the Description in column A in sheet3 so only the Descriptions need to be different.

Curt
0
 

Author Comment

by:rtod2
ID: 35175513
The name of the time zones aren't listed there.  Not sure what they are?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:rtod2
ID: 35175515
Central Time Zone is particularly important to have.
0
 

Author Comment

by:rtod2
ID: 35176922
Follow-up question >>  will award A+++ on both when fixed.
0
 

Author Comment

by:rtod2
ID: 35176923
0
 
LVL 18

Accepted Solution

by:
Curt Lindstrom earned 500 total points
ID: 35177046
Google will give loads of links:
USA time zone names
http://wwp.greenwichmeantime.com/time-zone/usa/time-zone-names.htm
North America time zones
http://www.timeanddate.com/library/abbreviations/timezones/na/
Time zones of Australia
http://www.statoids.com/tau.html

To enter them in the table in Sheet3 of your spreadsheet you just need to be able to type. You do not need an Excel expert

Cheers,
Curt
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now