Previous Topic Next Topic

Excel formula converting time difference

Solved/Closed
Mahesh - Feb 14, 2010 at 11:40 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 14, 2010 at 07:41 PM
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
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Feb 14, 2010 at 07:41 PM
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