Subtract the dates for each id

[Pinky]

Hi,

I want to subtarct the each date for each id like below. Can anyone send me sample workflow? Thanks in advance!

ID	Date	Seconds
AAA	2020-04-10 03:49:29	0
AAA	2020-04-10 03:54:44	315
AAA	2020-04-10 04:10:37	953
AAA	2020-04-10 07:52:02	13285
BBB	2020-04-10 15:42:05	0
BBB	2020-04-10 15:48:39	394
BBB	2020-04-10 15:52:52	253
CCC	2020-04-09 23:24:11	0
CCC	2020-04-09 23:45:32	1281
CCC	2020-04-10 00:16:19	1994

[JosephSerpis]

Hi @Pinky I mocked up a workflow let me know what you think?

[Pinky]

Thanks for your reply!

I am expecting the column output in seconds if i subtract the dates for each id like shown in table below.

ID	Date	Output - Seconds
AAA	2020-04-10 03:49:29	0
AAA	2020-04-10 03:54:44	315
AAA	2020-04-10 04:10:37	953
AAA	2020-04-10 07:52:02	13285
BBB	2020-04-10 15:42:05	0
BBB	2020-04-10 15:48:39	394
BBB	2020-04-10 15:52:52	253
CCC	2020-04-09 23:24:11	0
CCC	2020-04-09 23:45:32	1281
CCC	2020-04-10 00:16:19	1994

[PhilipL · Accepted solution]

Example with Seconds Calculated in new field

[JosephSerpis · Accepted solution]

Hi @Pinky apologies I misread your question have amended my worklfow.