EST DateTime to IST DateTime

[sridharr]

Hi All,

Good Morning.

We have server in Troy(USA).So we are in the situation to convert EST DateTime to IST DateTime in EXCEL.

If you have any formula or Idea share with me.

Eg; EST : 04/03/09 09:31:53 (I/P)
IST : 04/03/09 07:01:53 (O/P)

Thanks in Advance.

 

[VoG]

Try

=A1-"02:00"

 

[sridharr]

Nice but shootable for all cases.

 

[sridharr]

Sorry, It is not shootable for all cases.

 

[VoG]

Sorry, It is not shootable for all cases.

What does that mean

 

[sridharr]

Which means

The EST DateTime is 04/03/2009 11:00 PM (I/P)
The IST DateTime is 04/04/2009 8:30 Am (O/P)

 

[VoG]

So IST is 9 and a half hours ahead of EST? In which case

=A1+"09:30"

 

[sridharr]

Date should be changed from 04/03/09 to 04/04/09.

Good thinking.Proceed.....

 

[VoG]

<b>Sheet4</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:139px;" /><col style="width:136px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="text-align:right; ">04/03/2009 23:00</td><td style="text-align:right; ">04/04/2009 08:30</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >B1</td><td >=A1+"09:30"</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

 

[sridharr]

Nice Man.Thanks a lot.Its working perfectly.