identify time zone by looking at area code

[banneduser123]

I have a column full of phone numbers. I would like to be able to denote what time zone each number is in, in a separate column for each corresponding row.
How can I do this? I would imagine the formula would look at the first 3 digits for each number and then be able to identify what time zone it is…

Thanks a lot…

 

[banneduser123]

awesome....works great...thanks a lot for your help biff

 

[schielrn]

The only issue I see, is what do you do with area codes that belong to 2 time zones? I don't see how you can split that out, so you might have to list both or something?

 

[T. Valko]

awesome....works great...thanks a lot for your help biff

You're welcome. Thanks for the feedback!