Macro for converting Time Zone

Hi,

I am looking for a macro to convert time from IST to CST. I have attached the spread sheet, in which sheet2 is having IST & Sheet1 is having CST.

I need a Macro to look at ColumnC, ColumnD & ColumnE of Sheet2 and paste the converted result in sheet1 as shown in the attached sheet. It need to look till the last cell of ColumnA every time I run this, as the data is not constant. If any of the cell in empty then it need to copy empty cell instead of negative values.

I have used the following formula for converting the time

Please Login or Register  to view this content.

Thanks in advance for all your help!!

Regards,
Humac

Hello humacdeep,

The macro below has been added to a button on Sheet1. This will fill the table with the formulae to display the times.

Please Login or Register  to view this content.

Hello humacdeep,

I revised the macro and added it to the workbook below. Here is the revised code.

Please Login or Register  to view this content.

Hello humacdeep,

I assumed the table already existed on Sheet1 and the macro expects the same. It simply adds the needed formulas.

Hello humacdeep,

If you mean can the macro copy the table from Sheet2 to Sheet1 and then add the formulas to the table on Sheet1 then the answer is yes. If that is not what you want then I need more details.

alternative:

Please Login or Register  to view this content.

Hello humacdeep,

This version of the macro copies the table from "Sheet2" to "Sheet1" then adds the formulas. It has been added to the attached workbook.

Please Login or Register  to view this content.

Hello humacdeep,

You're welcome. Glad we got it straightened out and working right.