I have a table with distances made by several trucks, I need to detect the time when any of them drove more than 20 miles in less than an hour:

Date    Truck   Dist
05/11/2023 03:12:40 A   9.6
05/11/2023 03:43:25 A   6.5
05/11/2023 04:14:24 A   5.6
05/11/2023 04:43:55 A   7.4
05/11/2023 05:14:10 A   8.7
05/11/2023 05:24:39 A   8.9
05/11/2023 06:41:40 A   12.1
05/11/2023 04:13:33 B   11.5
05/11/2023 04:53:49 B   16.6
05/11/2023 06:14:04 B   7.4
05/11/2023 06:34:19 B   9.2
05/11/2023 07:04:34 B   9.5
05/11/2023 08:24:49 B   0.8

So in this example the return that I want should be:

Date    Truck   Dist
05/11/2023 04:14:24 A   21.7
05/11/2023 05:24:39 A   25
05/11/2023 04:53:49 B   28.1
05/11/2023 07:04:34 B   26.1

I made a macro in Excel that scans row by row and works fine but it takes a lot when I scan thousands of rows and was wondering if there can be a solution in SQL so I can save some time.

For i = 2 To lastrow
        t = i
        cont = Sheets("Data").Range("C" & i)
        Do While Sheets("Data").Range("B" & i) = Sheets("Data").Range("B" & i + 1) And DateDiff("s", Sheets("Data").Range("A" & i).Value, Sheets("Data").Range("A" & t).Value) <= 3600
            cont = cont + Sheets("Data").Range("C" & t)
            t = t + 1
            If cont >= 20 Then
            Sheets("Data").Range("D" & t) = cont
            i = t
            Exit Do
            End If
        Loop
Next