Excel formula converting time difference Solved/Closed

Question

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

venkat1926 · Accepted Answer

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.

Excel formula converting time difference

1 response

Similar discussions

Subscribe To Our Newsletter!