Date and time conversion to another time zone

How do I convert a given date and time of a time zone (USA) to the date and time of another time zone (Asia)? For example, in one column there is the USA date and time ( 5/12/12 4:30AM). How do I convert this in a formula in another column if the (Asia) date and time zone is ahead by 16 hours?

Welcome to the forum..

usually we do do it like this
A2 - (USA)

China is 8 hours ahead of GMT
and USA is 6 hours
total 14


we add 14

please check the specific country GMT


=A2+(14/24)