How to calculate time difference from below format

[mmustkee]

Hi Team,

Could you please help how to calculate time difference from below format. Appreciate your quick response, Please refer attached.

OUT_DATE_TIME	OUT_ARR_DATE_TIME	Duration
15-07-2024 08:10	15-07-2024 09:39
14-07-2024 17:16	14-07-2024 18:44
25-07-2024 15:53	25-07-2024 19:17
15-08-2024 16:30	15-08-2024 19:09
30-07-2024 17:27	30-07-2024 20:38
12-07-2024 06:38	12-07-2024 07:57
03-07-2024 07:16	03-07-2024 09:27
08-07-2024 17:29	08-07-2024 20:33
02-07-2024 07:28	02-07-2024 08:07
09-07-2024 15:48	09-07-2024 17:26
01-07-2024 08:21	01-07-2024 09:10
01-07-2024 15:43	01-07-2024 18:20
17-07-2024 16:25	17-07-2024 17:55
02-07-2024 10:52	02-07-2024 15:06
17-07-2024 07:23	17-07-2024 08:59

[OTrieger · Accepted solution]

@mmustkee 
Have you tried the formula DateTimeDiff(dt1,dt2,u)

[Qiu · Accepted solution]

@mmustkee 
We should use the DateTimeDiff function and before that we should parse the TimeStamps to the DateTime data format of Alteryx.