Time Difference

[Alteryx_Geek]

I am looking to find the delta between below timestamps (string format)

Example 1: 

                   2022-07-01 12:19:15.700
                   2022-07-01 12:19:15.800

                   The answer should be 0.1 sec as the output.

Example 2: 

                   2022-07-01 12:19:15.700
                   2022-07-01 12:19:20.700

                   The answer should be 5.0 sec as the output.

[OllieClarke · Accepted solution]

@Alteryx_Geek I rounded everything to 1dp based on your question, but if you remove the Round(.....,0.1) from the formula then that will no longer be the case:

So:

datetimediff(LEFT([time],19),LEFT([row-1:time],19),'seconds')
+
tonumber(substring([time],19))-tonumber(substring([row-1:time],19))

[Alteryx_Geek]

This is working as expected, thanks @OllieClarke