Excel formula converting time difference

Solved/Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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 2821 users have said thank you to us this month