Help in date and time conversion

Hi guys,

Please help me. I'm trying to convert the date to PST timezone from Manila timezone. However, due to the difference in the date and time format, some returns a #value error. Can someone check this sample file for me? I ried to seperate the time and date then change format, but still no avail.