$$Excel-Macros$$ Re: convert zip code or state to time zone

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 wrote: > > Hi there, > > Does anyone know of a formula or macro to conve

$$Excel-Macros$$ Re: convert zip code or state to time zone

Hi Michelle, I don't know such a formula. Maybe you could find a Database containing Zip Code, Area Code & Time Zone. Then write some SQL to get what you want. Eric --~--~-~--~~~---~--~~ ---