Converting Time Zone

Hi Everyone,

Im just new to this forum. My problem is I cannot convert a CST time zone to Manila Time. The data that I have to convert is in this format:

"12/15/2011 5:00:00 PM"

It is inside a SINGLE cell. Is there a way in excel that I can do this? Please help me. Thanks in advance.


- prodigy06

Assuming the Date is in A1 and there is a 14 hour difference then this should work
Make sure Cell is formatted to display as Date

Please Login or Register  to view this content.

Perfect! Thanks nashgas!


- prodigy06