Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 01-02-2014
Member
 
Join Date: Jun 2013
Posts: 77
Excel formula to calculate the time difference

How to calculate time difference of two countries in Microsoft Excel. I want some easy formula for the same. I had tried to go ahead with simple plus/minus. But that is giving me a wrong answer. I am not able to get the correct time through it. I want a simple formula through which I can get appropriate time output in a column. And I can also copy that in other sheets. I had seen some samples on web about this, but they are too confusing. It is hard to understand how it works.
Reply With Quote
  #2  
Old 03-02-2014
Member
 
Join Date: Mar 2011
Posts: 540
Re: Excel formula to calculate the time difference

You can use a online time zone convertor. This would be enough to calculate the time. I do not think a formula here can give you the exact result which you are looking. There are many online tools which give you simple calculator to calculate time.
Reply With Quote
  #3  
Old 03-02-2014
Member
 
Join Date: Jan 2014
Posts: 6
Re: Excel formula to calculate the time difference

Can you elaborate:

I simply formatted the cells as "Time" and I can add/subtract and get time differences easily.

I am using Excel 2007. What sort of problem are you having?
Reply With Quote
  #4  
Old 04-02-2014
Member
 
Join Date: Jun 2011
Posts: 798
Re: Excel formula to calculate the time difference

It is quiet simple. You just have to minus the time to get the difference. Excel is able to figure out that the numbers which you are subtracting are actually a time format. For example the time 1 is 6/9/2007 10:35 AM and time 2 is 6/9/2007 3:30 PM. You just have to subtract them and you will get the results. You can then simply drag the formula to get complete calculation for all. This one is fairly easy. Now if you want to find out what is the hours difference between two time then the formula for that is time 1 - time 2, "h". You have to just practice this one and then you will get the right output. You can find more information on the below link. Just click on that and get more details.
Calculate the difference between two times
Reply With Quote
  #5  
Old 05-02-2014
Member
 
Join Date: Jul 2011
Posts: 618
Re: Excel formula to calculate the time difference

I had tried some formula. Most of the time does not give you exact results. The best thing you can do is simply try out a web based calculator. This will be enough to fix the problem. You just have to copy paste the date and time in that.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel formula to calculate the time difference"
Thread Thread Starter Forum Replies Last Post
Need easy formula to calculate percentage in Microsoft Excel cupid! MS Office Support 2 23-02-2012 04:57 PM
How to calculate formula as per run rate in Excel (Cowherd) MS Office Support 2 15-02-2012 04:58 PM
I am looking for a formula to calculate compound interest in Excel Corey Dunnett MS Office Support 3 03-02-2012 06:05 PM
Looking for Excel formula which can calculate Lease and Balloon Payments Jigisha MS Office Support 2 01-02-2012 07:46 PM
Formula to Calculate Rate of Change in Microsoft Excel Lanka Boy MS Office Support 2 14-01-2012 03:49 PM


All times are GMT +5.5. The time now is 05:01 PM.