<div>
If cell A1 has IST time, and you want cell B1 to have EST time then do this<br />
In C1, type out the time difference between IST and EST in the hh:mm format and type this in B1<br />
<br />
=A1+ C1<br />
<br />
You will have to refer to web for the difference in timezone between the two.<br />
<br />
Sid
</div>


If cell A1 has IST time, and you want cell B1 to have EST time then do this
In C1, type out the time difference between IST and EST in the hh:mm format and type this in B1

=A1+ C1

You will have to refer to web for the difference in timezone between the two.

Sid

<div>
Oops beaten!<br />
<br />
Sid
</div>


<div>
ssaqibh: Bhai yeh &quot;cheenka&quot; kya hota hai? Peheli baar sun raha hoon :)<br />
<br />
<u>David</u>: I will pretend that you missed my post by mistake. And No, I am not talking from the points perspective but from the acknowledgment perspective.<br />
<br />
Sid
</div>


ssaqibh: Bhai yeh "cheenka" kya hota hai? Peheli baar sun raha hoon :)

David: I will pretend that you missed my post by mistake. And No, I am not talking from the points perspective but from the acknowledgment perspective.

Sid

<div>
Sid,<br />
<br />
Cheenka --&gt; sneezed. (I wonder if it is different in Hindi)<br />
<br />
<a href="https://www.experts-exchange.com/questions/26694071/Problem-in-Macro-codes-With-CreateObject-VBscript-RegExp.html#34400179" rel="ugc">https://www.experts-exchange.com/questions/26694071/Problem-in-Macro-codes-With-CreateObject-VBscript-RegExp.html#34400179</a><br />

</div>


Sid,

Cheenka --> sneezed. (I wonder if it is different in Hindi)

https://www.experts-exchange.com/questions/26694071/Problem-in-Macro-codes-With-CreateObject-VBscript-RegExp.html#34400179 [https://www.experts-exchange.com/questions/26694071/Problem-in-Macro-codes-With-CreateObject-VBscript-RegExp.html#34400179]


<div>
No it is the same :)<br />
<br />
I was not able to grasp it :)<br />
<br />
Sid
</div>


No it is the same :)

I was not able to grasp it :)

Sid

<div>
Maybe &quot;Chheenka&quot; would be a better way to spell it.
</div>


Maybe "Chheenka" would be a better way to spell it.

<div>
<div class="content wysiwyg-content">
Team,<br />
<br />
I have a column &quot;Date&quot; - 3/19/2011 3:16 which is in IST. Is there a formula which i can use to convert them into EST? Lets say NewYork Time?
</div>
</div>


Team,

I have a column "Date" - 3/19/2011 3:16 which is in IST. Is there a formula which i can use to convert them into EST? Lets say NewYork Time?

Excel 2010 Help - IST to EST

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.