Sort by state AND time zone?!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Calling all creative Excel users! I have client phone numbers in an Excel report, and want to somehow link the phone number to its time zone--and then sort the report by time zones! The purpose is to be able to assign outbound calls to staff at different times of the day, depending on time zone we are reaching

I'm possibly an advanced beginner in the user of Excel, so don't be afraid to be VERY detailed in your suggestion for a formula! I don't know how to use pivot tables, by the way..

Many thanks

Kay
 
Provided you can find a list of area codes/time zones, you could use another
column to assign
a number for the zone: i.e., 5 for Eastern US/Canada, 6 for Central US, 7
for Mountain, etc. and sort by that column.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
Kay said:
Calling all creative Excel users! I have client phone numbers in an Excel
Click to expand...
report, and want to somehow link the phone number to its time zone--and then
sort the report by time zones! The purpose is to be able to assign outbound
calls to staff at different times of the day, depending on time zone we are
reaching.
I'm possibly an advanced beginner in the user of Excel, so don't be afraid
Click to expand...
to be VERY detailed in your suggestion for a formula! I don't know how to
use pivot tables, by the way...
 
Back
Top