Excel Made Easy

How to do date and time zone conversion in excel in Excel

How to do Date + Time Zone conversion in Excel??

Hi Experts, I am seeking help to understand the way of doing Date/Time Zone conversion from one excel column to other column. 

In brief, Say I have a Date/Time value in mm/dd/yyyy HH:MM format in column A1 which is actually a PST Time, now I need a formula to convert it to IST format in column B1 but the Date/Time format should remain same i.e. mm/dd/yyyy HH:MM

I am not at all good in Excel so thought of seeking some assistance here. I feel it’s a complicated task and if anyone can help me…it will be great and I will be thankful from the bottom of my heart. 

Thanks again for sparing time to read my query. 

Cheers
Jsb

Answer:

IST is 12.5 ahead of PST so just enter in B1: =A1-"12:30:00"

and others answers can also be found Here

You can find similar Excel Questions and Answer hereunder

1) Our financial Year is divided into 13 periods of 4 weeks each. I enter weekly YTD data. In Excel, how can I set up Worksheet to get Period data automatically?

2) How can I add interval to dates?

3) I have a complex voluminous workbook with lot of formulas. Every time I make an update, the processing is slow. Any workarounds available?

4) How can i filter multiple columns simultaneously in Excel

5) how to write a formula in Excel

6) How can I execute an event at a predetermined time from my Macro?

7) How can I find the day of the week given a date?

8) Sumifs with date range as criteria in Excel

9) Excel 2010 vba replacement of application filesearch in Excel

10) I want to add a trend indicator symbol next to my sales data - how can I do that?