Auto Assigned Timezone Based On State

[JDX7913]

We have the user's state on our sys_user table. 

Has anyone gotten around to writing a business rule that would auto-assign the correct timezone based on the user's home state? The part that is tripping me up is that some states have two different timezone. How would I get around to that?

I know I can allow users to edit their own timezone, but my manager does not want to open that door up.

Could I do it based on the user's IP address?

Any idea would be greatly appreciated.

[DrewW]

You are going to have to know each users Zip Code and look it up or you are going to have to see if the needed info is in your HR system.  For us it was in our HR system so we just pulled it from there.