How can I calculate the difference of time for Attached file (Row 2 - Row 1).
@Alteryx_Geek
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-seconds-in-Alteryx/td-p/797269
@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
Hi @Alteryx_Geek
Try this, parsed the time and used @JarekSkudrzyk 's formula
@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-seconds-in-Alteryx/td-p/797269
