Macro to convert phone number to time zone

L

LindaC

Is it possible to create a macro to convert phone numbers to time zones? If
not, can you tell me how to create a macro that examines a phone number,
pulls out the area code, looks up in a list that maps that area code to a
time zone?

Thank you!
 
J

JE McGimpsey

You could use a Lookup table, but you should realize that

a) many area codes span time zones (like where I live - Idaho), and
b) to a greater extent every day, area codes are no longer fixed to
geography. More people keep their phone numbers when they move.
 
Top