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

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________