yBeginner Question -> Date time trim and difference

Hi Experts,

I am a beginner need your help..

I have date and time in a column. I want date and time in 2 columns ( i did it) and I want to find time difference of previous row per day.. Like the output as below. kindly support.

Column 1

2021-02-07 00:29:43
2021-02-07 01:29:26
2021-02-07 02:29:25
2021-02-07 03:43:24
2021-02-07 04:39:49
2021-02-07 05:57:16

2021-02-08 01:29:26
2021-02-08 02:29:25

Output

Date	Time	Difference
2021-02-07	01:29:26	00:00:00
2021-02-07	02:29:25	00:59:59
2021-02-07	03:43:24	01:13:59
2021-02-07	04:39:49	00:56:25
2021-02-07	05:57:16	01:17:27
2021-02-08	01:29:26	00:00:00
2021-02-08	02:29:25	00:59:59

Date Time

Accepted answers

Here is how you can do it.

Workflow:

1. Using formula tool to bring date to desired format.

2. Using multi-row formula to calculate time diff (seconds) of current row and prev row.

3. Using formula tool convert seconds into time format.

4. Using select tool to keep only required columns.

Hope this helps : )

time difference.yxmd

All comments

Here is how you can do it.

Workflow:

1. Using formula tool to bring date to desired format.

2. Using multi-row formula to calculate time diff (seconds) of current row and prev row.

3. Using formula tool convert seconds into time format.

4. Using select tool to keep only required columns.

Hope this helps : )

time difference.yxmd

@atcodedog05 Was faster, of course ;-), always is haha

and the solution i had.. haha

New Workflow3.yxmd

One more solution.....

Date time trim and difference.yxmd

Thanks all 🙂

Happy to help : ) @RKGV

Cheers and have a nice day!

How did it trim only the date ? without datatimeformat ?

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703