Macro for converting Time Zone

[humacdeep]

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

=Sheet2!C2-TIME(10,30,0)

Thanks in advance for all your help!!

Regards,
Humac