Hi Michelle, You can create one excel file which contains all location names of US with their time zones and then you can use Vlookup function. This would solve your problem.
On Wed, Mar 11, 2009 at 3:53 AM, Michelle G <michellabe...@gmail.com> wrote: > > Hi there, > > Does anyone know of a formula or macro to convert location (zip or > state) to a time zone? (US only) > > Thanks! > > ~Michelle > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
