Excel Time format: From GMT to Malaysian Time

**ymredzu** · 03-11-2013, 11:42 PM

Hi Guys and Gals,

Need some help to figure out on how to change a GMT time zone to a malaysian time zone (GMT + 8), Let say for an E.G the file attached :-

In coulmn D i have GMT and i would like to have a malaysian time zone in Coulmn E how can i do that?

**etaf** · 03-12-2013, 06:17 AM

use this
=D1+TIME(8,0,0)
Malaysian is +8 hours of gmt

**ymredzu** · 03-13-2013, 08:02 AM

Hi Etaf,

Thanks for the help, appreciated it..... i have another issue maybe you can help.... emmm ok, If you look at the screen shot attached in column [ O ](Solution) there will have a few line of values in it.... is there any way i can remove a line that have the word Escalation in it to another column or any thing similarExcelforum.jpg to it?