Calculate Time difference

[Alteryx_Geek]

How can I calculate the difference of time for Attached file (Row 2 - Row 1). 

[JarekSkudrzyk]

@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-sec...

[Alteryx_Geek]

@JarekSkudrzyk  - I tried, it didnt work

[JarekSkudrzyk]

@Alteryx_Geek 
in the meantime I have edited my previous post - please take a look at it and let me know if it helps.

[Alteryx_Geek]

@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

[Luke_C]

Hi @Alteryx_Geek 

Try this, parsed the time and used @JarekSkudrzyk 's formula

[Qiu]

@Alteryx_Geek 
By extra logic, I guess you mean we need to parse the time string out.

[Alteryx_Geek]

@Luke_C  - Thanks Luke, appreciated. Is it possible to get the time difference in msec ? or something like in this format "ss.msec" ?

[Alteryx_Geek]

@Qiu - Thanks Qui, appreciated. Is it possible to get the time difference in msec ? or something like in this format "ss.msec" ?

[Luke_C]

Hi @Alteryx_Geek 

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...