+ Reply to Thread
Results 1 to 4 of 4

Need Help with an user form that convert GTM Time to Other selected Time Zone

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    Maryland, USA
    MS-Off Ver
    Excel 365
    Posts
    105

    Need Help with an user form that convert GTM Time to Other selected Time Zone

    Dear All,

    I got help on an user form that allow me to convert Zulu time to Eastern Time and work perfectly but now I'm recieving data with other time zone so i need to modify my user form. I added a sheet 2 with all the time zone: Abbreviation, Name and The time different with Zulu Time also added a list box to the user form to select the desire time zone conversion.

    The problem is that i know how i want it to work but no how to do it :confused:

    This is how I want it to work:

    1-Enter the date in Zulu Time text Box1
    2-Select the desire Time Zone Coversion from the List Box1
    3-When press enter on the convert botton it will enter the result in the Text box 2.

    I was thinking to do it with formula but I'm not sure how and i have been stock on this for few days :confused:

    Any sugestion is highly appreciated and thank you in advance for your time.

    I had attached the file so you will be able to see what i have so far.

    Respectfully,

    Alex
    Attached Files Attached Files

  2. #2
    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: Need Help with an user form that convert GTM Time to Other selected Time Zone

    You surely don't need VBA or a userform for this.

    Enter the Zulu time in a cell, select another time zone in a drop-down in another cell, and use a formula:

    A
    B
    C
    D
    E
    F
    G
    H
    1
    Zone
    Full name
    Location
    UTC+
    2
    A Alpha Zone Military
    10.00
    Zulu
    05/06/2014 13:13
    3
    ACDT Australian Central Daylight Australia
    10.50
    AEDT
    05/07/2014 00:13
    G3: =G$2 + LOOKUP(F3, $A$2:$D$217)/24
    4
    ACST Australian Central Standard Australia
    9.50
    AMST
    05/06/2014 10:13
    5
    ADT Atlantic Daylight North America
    -3.00
    6
    AEDT Australian Eastern Daylight Australia
    11.00
    7
    AEST Australian Eastern Standard Australia
    10.00
    8
    AFT Afghanistan Asia
    4.50
    9
    AKDT Alaska Daylight North America
    -8.00
    10
    AKST Alaska Standard North America
    -9.00
    11
    ALMT Alma-Ata Asia
    6.00
    12
    AMST Armenia Summer Asia
    5.00
    13
    AMST Amazon Summer South America
    -3.00
    14
    AMT Armenia Asia
    4.00
    15
    AMT Amazon South America
    -4.00
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    03-14-2013
    Location
    Maryland, USA
    MS-Off Ver
    Excel 365
    Posts
    105

    Re: Need Help with an user form that convert GTM Time to Other selected Time Zone

    SHG,

    Thank you very much for your fast response, but i cannot use your apporach because i don't have an spreadsheet to be listed like that, what i have are two web databases one that store the data with zulu time and another that store the data in the local tame wherever the costumer is, my work is to match those data an use an userform i had created to collect the correct set of data from both datasource and loaded to a reporting spreadsheet.
    the reason i want to use the userform is to incorporate it into the userform i had already so i can do the conversion as soon as i enter the date and time for the first datasource.
    the user form that i had attached do that but just for the Easter Time zone.
    but with your apporach it is posible to add that formula to an extra columm in my sheet2 and so how make the text box2 to populate the result of the formula in text box2 after you select a time zone from the list box.
    this can be an idea but i can't make it to work

    Respectfully,

    Alex

  4. #4
    Forum Contributor
    Join Date
    03-14-2013
    Location
    Maryland, USA
    MS-Off Ver
    Excel 365
    Posts
    105

    Re: Need Help with an user form that convert GTM Time to Other selected Time Zone



    Any sugestion??, I'm stock here and falling behind.

    thanks for your time.

    Respectfully,

    Alex

+ 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] Need Help with an user form that convert GTM Time to Easter Time
    By odoualex in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2014, 11:14 AM
  2. [SOLVED] Converting Time Values from One Time Zone to Another
    By Debraj Roy in forum Excel General
    Replies: 7
    Last Post: 09-03-2013, 06:49 AM
  3. formula to return a certain Time Zone depending upon country user inputs
    By nufc_demon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2008, 07:25 AM
  4. [SOLVED] How to set a formula to convert the time zone
    By Calculate Date range in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-20-2006, 03:50 AM
  5. How to convert phone area-code to state name and time zone
    By NoYouShmoopie in forum Excel General
    Replies: 2
    Last Post: 10-07-2005, 10:05 AM

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