+ Reply to Thread
Results 1 to 2 of 2

Sorting by Time Zone with a lookup command

  1. #1
    Registered User
    Join Date
    09-13-2021
    Location
    MN, USA
    MS-Off Ver
    365
    Posts
    1

    Sorting by Time Zone with a lookup command

    Hello,

    Everyday I am constantly creating call lists to reach out to prospects for my company. In my sheets I have the name of the individual/Business and numbers, I have to follow the DNC guidelines and hours I can solicit. With that being said I am trying to maximize my time by calling on est time zone earlier and pacific later. Is there a way I can create a master key where I can list all of the area codes for each time zone and have excel organize them for me?

    The entire number is in one cell, is there a formula that can compare the first three numbers in a cell to a master key that then lists which timezone it is in?
    612-240-6939
    612-239-5529
    312-344-0632
    612-203-2147
    202-374-3379
    612-300-7689
    803-394-1220
    612-965-0427
    617-416-9140
    763-427-1444
    313-753-0567
    612-805-9095
    763-999-0644
    763-242-5959
    763-234-4288
    715-426-9505
    704-819-1704
    604-792-8804

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,701

    Re: Sorting by Time Zone with a lookup command

    Here you go. You can put the area code on a separate sheet from your phone numbers. I just put them on the same sheet to demonstrate.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculating Corrected Time Based on Time Zone
    By Falk781 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-30-2020, 01:30 PM
  2. How to convert from indian time zone to US time zone
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-18-2018, 05:42 AM
  3. Input: Time Zone. Output: Current Time
    By imsteve123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2015, 09:16 PM
  4. Lookup number within a range and return zone.
    By ZeDoctor in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-06-2015, 01:49 PM
  5. Need Help with an user form that convert GTM Time to Other selected Time Zone
    By odoualex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2014, 11:52 AM
  6. Date and time conversion to another time zone
    By RUBEN PARRAS in forum Excel General
    Replies: 1
    Last Post: 05-21-2012, 09:03 PM
  7. sorting by time zone based on zip codes
    By rooshio in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2009, 07:57 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1