Does anyone know how to convert different time zones by state into one time zone?

[Dong Dong]

City (Origin)	State (Origin)	City (Destination)	State (Destination)	Departure Time	Arrival time
Fort Lauderdale	FL	Asheville	NC	700	854
Asheville	NC	Fort Lauderdale	FL	945	1134
Fort Lauderdale	FL	Newark	NJ	1200	1400
Newark	NJ	Las Vegas	NV	1500	1900
Las Vegas	NV	Charlotte	NC	2000	2300

This is an example, not the true data. The given departure time and arrival time are all given based on its local time. Plus, when it comes to departure time and arrival time, 700 is 7:00 (AM) and 854 refers to 8:54 (AM). Likewise, 1200 is 12:00 (PM) and 2300 is 23:00 (PM) local time.

Do you know how to convert each and every departure and arrival time according to EST (For example) ? I was wondering if there is any command or tools to make them consistent with each other.

Thank you.

[Fei Wang]

Dong, I think you need another variables indicating the time zone for each location, like PST for NV, and EST for FL, and then convert time based on the time zone variables. I don't think Stata is smart enough to automatically convert time based on location names. Moreover, time conversion should take daylight time scheme into account if dates are available.

[Clyde Schechter]

Adding to Fei Wang 's excellent advice, you will need fairly detailed location information to do this. There are 14 states that straddle two time-zones. In fact, FL is one of them: its panhandle stretches into the central time zone. So just knowing the state isn't enough.