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.
Solved! Go to 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))
This is working as expected, thanks @OllieClarke