Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date Time Difference

Feras95p
8 - Asteroid

Dear all,

 

As you can see in the file attached I have two columns Start time and end time , I want to have in a column the difference between these two columns in "hours" any help in that please?

2 REPLIES 2
binuacs
20 - Arcturus

@Feras95p 

 

binuacs_0-1640760557399.png

 

Qiu
20 - Arcturus
20 - Arcturus

@Feras95p 
We can also use the DateTime tool to convert the time.
And also there are some rows as "As soon as possible", and I have removed them from the input data.

1229-Feras95p-A.PNG1229-Feras95p-B.PNG

Labels