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
Bookmarks