How to Display

[rskip]

I am on Excel 365
I have a spreadsheet that tracks stats for a racing league. 1 Category is interval. This is generally easy to calculate. However the data i get is in seconds, still easy to change to mm:ss.000, however where I am having a problem is if a racer is 1 Lap down.
This is the formula I use
=IFERROR(INDEX(' Week 10'!AH$4:AH$100,MATCH(B1149,IF(' Week 10'!A$4:A$100=AR$1147,' Week 10'!C$4:C$100),0))/10000/86400,"DNR")
Column AH (the data) looks like this
So 1 Lap down is reported as -1, or -2 for 2 laps down

So my results are like this:
Thanks any help is appreciated !

Race Interval

0:00.000

0:00.905

0:16.550

0:25.701

0:35.891

0:36.691

1:07.258

##########

Data

interval​

9045​

165501​

257015​

358913​

366912​

672583​

-1​