Originally Posted by Shaun

I am stuck and Google is not my friend at the moment.

I have 2 times in excel a current time and the race time, i meed to find the difference between them.

I have tried a few different formulas like.
=DK6 - DK5 + (DK5 < DK6)

But i am getting a difference of 22 hours

i know it has something to do the format of the time or such.

Here are the time

Race time 12:35:00pm
Current time 11:02:52am

Here are the times as numbers.
0.52
41126.46