Timezone Formula for US States

I thought this might be useful for others, as I had to figure out how to do it for myself to automate sending emails during the right timezone for the recipient; here’s a list of all the timezones for US states:

IF(OR({State}="CA", {State}="WA", {State}="OR", {State}="NV"), "PST", IF(OR({State}="MT", {State}="ID", {State}="WY", {State}="SD", {State}="UT", {State}="CO", {State}="AZ", {State}="NM"), "MST", IF(OR({State}="ND", {State}="MN", {State}="WI", {State}="IA", {State}="NE", {State}="IL", {State}="KS", {State}="MO", {State}="OK", {State}="AR", {State}="TN", {State}="TX", {State}="LA", {State}="MS", {State}="AL"), "CST", IF(OR({State}="MI", {State}="IN", {State}="OH", {State}="ME", {State}="VT", {State}="NY", {State}="NH", {State}="MA", {State}="CT", {State}="RI", {State}="PA", {State}="NJ", {State}="MD", {State}="DE", {State}="WV", {State}="KY", {State}="VA", {State}="NC", {State}="SC", {State}="GA", {State}="FL", {State}="DC"), "EST", IF({State}="AK", "AST", IF({State}="HI", "HST"))))))

There are some rare exceptions of states in two timezones and some states that don’t observe Daylight Savings Time that I definitely didn’t account for, but hey – you get what you pay for guys :slight_smile:

3 Likes