Time Difference

[henrygeorge]

How do I get the difference between this time1  table

Record ID	Time1
1	06:44:39
2	06:19:32
3	06:19:13
4	06:19:16
5	06:19:07
6	06:11:09

And this time 2 table -

Record ID	Time2
1	11:43:57
2	11:18:40
3	11:18:25
4	11:18:32
5	11:18:22
6	11:08:05

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

[Jean-Balteryx]

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]

@Jean-Balteryx yes that would be helpful!

[Jean-Balteryx · Accepted solution]

@henrygeorge ,

Here it is !

Cheers,

Jean-Baptiste

[henrygeorge]

@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]

@henrygeorge ,

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

Cheers,

Jean-Baptiste

[Jean-Balteryx]

@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