Timezone Convertion

[un_sub]

hi Guys im a noob here, im trying to convert a one timezone to other using a formula in excel.

example: format is in 24hrs

01:00 EST to be converted to Taipei or Beijing timezone vice versa

thanks in advance guys

 

[drsarao]

The time difference between EST and Beijing/Taipei is 13 hrs. (12 hrs if you take Daylight Savings into account)

If the original time is in A1 then:

For EST->Taipei
=A1+TIME(13,0,0)

For Taipei->EST
=A1-TIME(13,0,0)

 

[un_sub]

Thanks so much for the Help...

 

[drsarao]

You are welcome.