Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

Excel formula converting time difference [Solved/Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 -
Hello,
i want to know the excel formula...below iam giving the details,
In table A is my starting time e.g.10.49 and in table B is my reaching time e.g.12.12 the difference value will be in table C is 1.63, want to convert this value in to minutes by using Excel formula.....please help me

1 reply

Answer 1 / 1
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 798
first at least in my region the time is entered like this
10:49
12:12
etc a colon between the minutes and seconds.

suppose the first time is in A1
and second in B1
in any cell e.g. C1 type this formula
=B1-A1
format C1 as time without AM or PM

in C1 you will get 1:23 (not 1.63) means one minutes 23 seconds.
2
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!