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

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
792
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

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

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!