date-time conversion

[kxlvba]

I have the following date-time entered in excel in format. "m/d/yy h:mm AM/PM"
Now this time is in US Central time. I need to convert this time keeping it in the same format to my countries time which is 11hrs & 30 mins ahead of US Central time. What should I do.
I know sub/add times values but that is not possible as date part is also involved.

 

[Norie]

If this is a true date/time value then you should just be able to add the time.

=A1+TIME(11,30,0)