How to compare seconds in excel

[CunningStunts]

Hi guys,

I'm comparing horse racing times for my trading and when I'm comparing seconds there's one problem tripping me up. I'll give an example so its clear. The first times is the overall win time and the second time's are the horses actual times. These will be displayed as seconds and milliseconds

Horse #1 12.30 12.47
Horse #2 13.40 14.02
Horse #3 13.50 14.10

Here's my main issue, when I enter the times into excel the first horse won't be an issue because the time doesn't cross over the minute barrier but unless I calculate them manually which take ages, I'll have the second horses time showing as a 62 second time difference when in reality its actually only 22 seconds. Same with the third horse, it would show 60 seconds instead of 20 seconds. How can I fix this please? What's the formula?

 

[Dr. Demento]

It's just a matter of converting your times (which are a mash-up of decimal and min:sec).

For example, 12.3 (I assume) is 12:30 (mm:ss). To convert this to a true decimal (12.5), use this formula:

=INT(B1)+(((B1-INT(B1))*100)/60)

This turns the decimal portion into a percentage and multiply by 60. Do this for each split.
Calculate the difference by simple subtraction.
Multiply the final result by 60 to get the final answer as seconds.

 

[Fluff]

Another option

Fluff.xlsm
	A	B	C
1
2	12.3	12.47	0.17
3	13.4	14.02	0.22
4	13.5	14.1	0.2
Data

Cell Formulas
Range	Formula
C2:C4	C2	=DOLLARFR(DOLLARDE(B2,60)-DOLLARDE(A2,60),60)

 

[Dr. Demento]

Holy CrapTastic, Fluff!! Where do you come up with this knowledge?!

 

[Fluff]

From seeing what other people on here use.

 

[Dr. Demento]

Well, thank you for making me a bit more knowledgeable!

 

[CunningStunts]

Amazing! Thank you both for your answers, couldn't for the life of figure it out

 

[Fluff]

Glad we could help & thanks for the feedback.