Excel 2010 Help - IST to EST

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?
LVL 2
davidi1Asked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Simply subtract n/24 to the IST date where n is the difference in hours between the two standards.

Saqib
0
 
SiddharthRoutCommented:
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
0
 
SiddharthRoutCommented:
Oops beaten!

Sid
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
Saqib Husain, SyedEngineerCommented:
Tum phir cheenka!!!
0
 
SiddharthRoutCommented:
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
0
 
Saqib Husain, SyedEngineerCommented:
0
 
SiddharthRoutCommented:
No it is the same :)

I was not able to grasp it :)

Sid
0
 
Saqib Husain, SyedEngineerCommented:
Maybe "Chheenka" would be a better way to spell it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.