Solved

Excel 2010 Help - IST to EST

Posted on 2011-03-23
8
2,004 Views
Last Modified: 2012-06-27
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
Comment
Question by:davidi1
  • 4
  • 4
8 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 35201842
Simply subtract n/24 to the IST date where n is the difference in hours between the two standards.

Saqib
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35201848
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
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35201852
Oops beaten!

Sid
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 35201873
Tum phir cheenka!!!
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35201939
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
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 35202048
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35202361
No it is the same :)

I was not able to grasp it :)

Sid
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 35202420
Maybe "Chheenka" would be a better way to spell it.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Macro to Send Appointment from Excel 1 29
Excel Pivot Table with No Summary Fields 7 29
TT Column Arrange 10 28
Convert .PDF 6 38
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now