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
Solved! Go to Solution.
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
@Jean-Balteryx yes that would be helpful!
@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?
I replied in the post you created about that with the workflow modified.
Cheers,
Jean-Baptiste
If the answer about time difference helped you, please mark it as solution for other people to find it more quickly.
Cheers,
Jean-Baptiste