Move time difference to the actual time

smfhsan2005

Hello Experts, I have a request seems little easy I did worked on that but not getting the actual result. Your help will be really appreciated. Here is the scenario. Below table has time difference of 2 sec ,I want that value 2  to come at 21:51:47..shown below. same with time value 3.

Date	Time	Time diff
10/21/2019	21:51:45	0
10/21/2019	21:51:46	0
10/21/2019	21:51:47	0
10/21/2019	21:51:48	0
10/21/2019	21:51:49	2
10/21/2019	21:51:50	0
10/21/2019	21:51:51	0
10/21/2019	22:36:23	0
10/21/2019	22:36:24	0
10/21/2019	22:36:25	0
10/21/2019	22:36:26	0
10/21/2019	22:36:27	3
10/21/2019	22:36:28	0
10/21/2019	22:36:29	0
10/21/2019	22:36:30	0
10/21/2019	22:36:31	0
10/21/2019	22:36:32	0
10/21/2019	22:36:33	0

Expected result:

Date	Time	Time diff
10/21/2019	21:51:45	0
10/21/2019	21:51:46	0
10/21/2019	21:51:47	2
10/21/2019	21:51:48	0
10/21/2019	21:51:49	0
10/21/2019	21:51:50	0
10/21/2019	21:51:51	0
10/21/2019	22:36:23	0
10/21/2019	22:36:24	3
10/21/2019	22:36:25	0
10/21/2019	22:36:26	0
10/21/2019	22:36:27	0
10/21/2019	22:36:28	0
10/21/2019	22:36:29	0
10/21/2019	22:36:30	0
10/21/2019	22:36:31	0
10/21/2019	22:36:32	0
10/21/2019	22:36:33	0

Thanks

danilang

Hi @smfhsan2005 

Here's a workflow that does it all

The filter finds the rows with non-zero time differences.  The lower formula figures out which rows to update and these are joined.  The top filter set the time diff to 0 on the old rows.  All of these, the 2 new, the 2 old and the remainder are unioned together and sorted by date time

 

Dan

timeDiff.yxmd