Questions? Comments? Rants? Read Our FAQ & Contact Us
Creative ways to save time and money, especially for corporations.

Subscribe to the Freedom from Organization: Corporate Edition RSS feed

Subscribe to Freedom from Organization: Corporate Edition via email.

Like what you read here? Say thanks with a Guinness!

NoTimeForNOW.com

by Marina Martin | Filed under: Do It Better

If you have a list of accounts to call, it’s useful to sort them by time zone so you know which accounts need to be called first/last.

The following custom formula field assigns a time zone based on the state or province. For states/provinces in multiple time zones, it assigns the time zone of the majority of that region. (In other words, it may be off by an hour in some places, but it does the trick.)

IF(LEN( BillingState)=0, “None”,
IF(CONTAINS(”CT:DC:DE:FL:GA:IN:ME:MD:MA:MI:NH:NJ:NY:NC:OH:PA:RI:SC:VT:VA:WV:ON:QC:NB:NS:NL:PE”, BillingState), “GMT-5 Eastern”,
IF(CONTAINS(”AL:AR:IL:IA:KS:KY:LA:MN:MS:MO:NE:ND:OK:SD:TN:TX:WI:SK:MB:NU”, BillingState), “GMT-6 Central”,
IF(CONTAINS(”AZ:CO:ID:MT:NM:UT:WY:AB:NT”, BillingState), “GMT-7 Mountain”,
IF(CONTAINS(”AK”, BillingState), “GMT-9 Alaska”,
IF(CONTAINS(”HI”, BillingState), “GMT-10 Hawaii”,
IF(CONTAINS(”CA:NV:OR:WA:BC:YT”, BillingState), “GMT-8 Pacific”, “Other”)))))))


First posted on February 19, 2008

No Comments »

No comments yet.

Click here to subscribe to comments to this post | TrackBack URL

Leave a comment