Time Zone descriptor needed in Col B

Posted on 2011-03-19
Medium Priority
Last Modified: 2012-05-11
Column B needs time zone descriptor also.

Example UTC -5:00 Central Time, US.  
Also the plus(+) or minus(-) sign in front of the zone should be stated explicitly.

my sheet >> https://spreadsheets.google.com/ccc?key=0ApGg6c9aeywQdGZ5VzcxZHljZkJjQmJ5Y2hJMFgzYUE&hl=en
potential examples >> http://www.michaelapproved.com/articles/timezone-dropdown-select-list/

Assistance is greatly appreciated.
Question by:rtod2
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
LVL 18

Expert Comment

by:Curt Lindstrom
ID: 35174191
I think I got this working now. I'm just fixing up the descriptor table a little


Author Comment

ID: 35174224
You're amazing!
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 18

Expert Comment

by:Curt Lindstrom
ID: 35174263
Thanks, glad to help. Next question seems to be well in the hands of user 5111.

LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 35174271
I need to understand this.
Are we updating the info at google?
Do we save it back there?
What happens if more than one users save it with different updates?

In any case I think we should be posting the results in this forum because the sheets may be deleted from google and this question looses its functionality.

LVL 18

Expert Comment

by:Curt Lindstrom
ID: 35174318
You are right Saqib. The only reason I haven't posted anything back was that question was accepted after I updated the google spreadsheet and before I got back to the question. The solution also becomes somewhat irrelevant in this case since it will only work on the google spreadsheet. Anyway using the now updated version:

Tables changed in sheet3 to add a description i A and Time Zones in B
enter in C2
=if(A2="","",mid(text(now()+vlookup(B2,sheet3!A:B,2,false)/24+5/24,"'Weekday 'EEE"),8,10))
and copy down
enter in E2
=if(A2="","",text(now()+vlookup(B2,sheet3!A:B,2,false)/24+5/24,"hh:mm:ss a"))
and copy down
enter in F2
and copy down

LVL 18

Accepted Solution

Curt Lindstrom earned 2000 total points
ID: 35174352
This is a copy of the google spreadsheet which currently is working. It will not work properly in Excel bu all formulas used in this question and related questions can be seen.


Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

771 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