Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Time Difference

henrygeorge
8 - Asteroid

How do I get the difference between this time1  table

Record IDTime1
106:44:39
206:19:32
306:19:13
406:19:16
506:19:07
606:11:09

 

And this time 2 table -

Record IDTime2
111:43:57
211:18:40
311:18:25
411:18:32
511:18:22
611:08:05

 

In just a way I output the difference if the two in HH:mm:ss format

6 REPLIES 6
Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @henrygeorge ,

 

You can join your tables using RecordID then use the function DateTimeDiff in a formula tool to get the difference between both or your times.

 

Do you want an example workflow ?

 

Cheers,

 

Jean-Baptiste

henrygeorge
8 - Asteroid

@Jean-Balteryx yes that would be helpful!

Jean-Balteryx
16 - Nebula
16 - Nebula

@henrygeorge ,

 

Here it is !

 

Cheers,

 

Jean-Baptiste

henrygeorge
8 - Asteroid

@Jean-Balteryx Thank you so much. If I want to now add 04:59:00 to all the Time1's how do I do that?

Jean-Balteryx
16 - Nebula
16 - Nebula

@henrygeorge ,

 

I replied in the post you created about that with the workflow modified.

 

Cheers,

 

Jean-Baptiste

Jean-Balteryx
16 - Nebula
16 - Nebula

@henrygeorge ,

 

If the answer about time difference helped you, please mark it as solution for other people to find it more quickly.

 

Cheers,

 

Jean-Baptiste

Labels