Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Use function ConverToLocalTime(Timedim,'UTC')
HTH,
Sushil
Hi
try this
=ConvertToLocalTime('04-11-2013 21:53:00','Kuala Lumpur')
Hey,
Your above formula is giving wrong timing according to malaysia
ConvertToLocalTime('04-11-2013 21:53:00','UTC+08:00')
this should work
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 ??
Do one thing then
Convert to UTC00:00 then to utc+08:00
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,