converting date and time to EDT/EST TimeZone

**stoey** · 05-14-2009, 05:09 AM

hi,

Can anyone help me how to make a macro or formula on how to convert date and time into EDT/EST time zone format? User enter's date and time in any timezone format then the output will always be in EDT/EST format...like if user enters: 05/13/2000 05:00:00 -700 or 05/13/2000 05:00:00 AM PST then the output would be :
EDT format is: 05/13/2000 02:00:00 AM EDT
EST format is: 05/13/2000 01:00:00 AM EST

Regards,

Stoey

**stanleydgromjr** · 05-14-2009, 08:32 AM

stoey,

Try:
Time Zones And Daylight Savings Time
http://www.cpearson.com/excel/TimeZo...lightTime.aspx

**stoey** · 05-14-2009, 06:27 PM

hi

thanks for the info stanley but i don't know how to get is started...are there any other examples which can be more less complicated for me?

thanks,

stoey

**martindwilson** · 05-14-2009, 08:37 PM

how do you know when dst kicks in?

**stoey** · 05-14-2009, 11:15 PM

hi martin,

basically there will be 2 conversion output, that is EST and EDT time. User needs to only input the date and time format which is like the example i have above and then simply output the converted time format which is on EST and EDt once a button is click...Sorry I forgot to indicate on my sample worksheet that there should be a CONVERT NOW button.

Thanks,

Stoey

**martindwilson** · 05-15-2009, 08:47 AM

i think rather than being too clever you should adopt a drop down method
first cell could be user entered date second could be a drop down where they choose time in hours froom 00:00 to 23:00 third cell could be another drop down where they choose zone or +/- time.
then with a bit of formula crunching it could pick the right conversion from a table.

**stoey** · 05-15-2009, 10:07 AM

hi martin,

im open with your suggestion, if its okay for you to show me then i could probably adapt and just make a little tweaking on your suggestion. I appreciate it thanks

Stoey