How can I calculate the difference of time for Attached file (Row 2 - Row 1).
Hi,
you need to use DateTimeDiff(dt1,dt2,u) function in a multi-row formula tool.
This will give you difference in seconds. If you want difference in smaller units (e.g. miliseconds) - please take a look at this post:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-get-datetimediff-with-milli-sec...
@JarekSkudrzyk - I tried, it didnt work
@Alteryx_Geek
in the meantime I have edited my previous post - please take a look at it and let me know if it helps.
@JarekSkudrzyk - I think your logic works, but looks like i need to apply some more logic to get to this point. I am attaching the file, can you please help in getting the time difference for this file
@Alteryx_Geek
By extra logic, I guess you mean we need to parse the time string out.
@Luke_C - Thanks Luke, appreciated. Is it possible to get the time difference in msec ? or something like in this format "ss.msec" ?
@Qiu - Thanks Qui, appreciated. Is it possible to get the time difference in msec ? or something like in this format "ss.msec" ?
As @JarekSkudrzyk mentioned above, did you check out this link? https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-get-datetimediff-with-milli-sec...