+ Reply to Thread
Results 1 to 2 of 2

sorting by time zone based on zip codes

  1. 03-11-2009, 01:15 PM #1
    rooshio
    rooshio is offline
    Registered User
    Join Date
    03-11-2009
    Location
    Utah
    MS-Off Ver
    Excel 2007
    Posts
    6

    sorting by time zone based on zip codes

    i'm compiling a list of several hundred businesses across the country that i want to be able to sort by time zone.

    say for example I have zip codes listed in Column A. Is there a formula I can have in Column B that will return which time zone a particular zip code belongs to?

    here are some links that might help

    zip prefixes http://en.wikipedia.org/wiki/ZIP_code_prefixes
    zip code map http://en.wikipedia.org/wiki/ZIP_Code
    time zone map http://www.timetemperature.com/tzus/time_zone.shtml


    thanks in advance,
    noob
    Reply With QuoteRegister To Reply
  2. 03-11-2009, 07:57 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: sorting by time zone based on zip codes

    You need a master list someplace that has the time zone for each zip code. And then probably, for each time zone, the GMT offset (which varies, for some, by season). Then you can use a VLOOKUP formula to retrieve the time zone for a given zip, and another to retrieve the current offset.

    If you need help, you gather the source material, and then post an example of what you're trying to do.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1