Formula for converting IST to Malaysian timing ??

[nikhilgarg]

HEy,

I have a column of date in IST:  

04-11-2013 21:53:00

I want to convert it to malaysian timing in excel sheet . I could not find it on net.

Pls help me.

Thanks

[sushil353]

Hi,

Use function ConverToLocalTime(Timedim,'UTC')

HTH,

Sushil

[arulsettu]

Hi

try this

=ConvertToLocalTime('04-11-2013 21:53:00','Kuala Lumpur')

[nikhilgarg]

Hey,

Your above formula is giving wrong timing according to malaysia

[sujeetsingh]

ConvertToLocalTime('04-11-2013 21:53:00','UTC+08:00')

this should work

[nikhilgarg]

Hey,

If my IST timimg now is 13:00 then in Malaysia , it is : 3:30 pm.

Then how does above formula right for malaysia ??

[sujeetsingh]

Do one thing then

Convert to UTC00:00 then to utc+08:00

[nikhilgarg]

Hey,

I tried in this way but no value shown in D@ column:

Time([Event Start Time], 'hh:mm:ss') as StartTime,

    ConvertToLocalTime('StartTime','UTC+00:00')as d1,

    ConvertToLocalTime('d1','UTC+08:00')as d2,