excel - Time subtraction with ms involved -

i have csv file data this:

1,success,19:1:6:445  1,success,19:1:7:652  1,success,19:1:10:172  1,success,19:1:11:500  1,success,19:1:12:893 ...

the goal calculate time difference row above. example, duration row 1 row 2 = 1000ms + 652-445ms = 1207 ms

first, load csv excel , parse using text columns below:

enter image description here

result this:

enter image description here

use formula in g1 millisecond difference.
=sumproduct(c2:f2-c1:f1,{3600000,60000,1000,1})
, there have millisecond difference.

GHI