Macro to convert phone number to time zone

[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!

 

[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.