Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2342
  • Last Modified:

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?
0
davidi1
Asked:
davidi1
  • 4
  • 4
1 Solution
 
Saqib Husain, SyedEngineerCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now