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.
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.