yBeginner Question -> Date time trim and difference

[RKGV]

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

[atcodedog05 · Accepted solution]

Hi @RKGV 

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 : )

[Sebastiaandb]

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

[Sebastiaandb]

and the solution i had.. haha

[atcodedog05]

Hi @Sebastiaandb 

I like how you managed to arrive at time thats nice method 😀👍. I will take it for reference 🙂.

[binay2448]

One more solution.....

[RKGV]

Thanks all 🙂 

[atcodedog05]

Happy to help : ) @RKGV 

Cheers and have a nice day!

[RKGV]

How did it trim only the date ? without datatimeformat ?

[atcodedog05]

Hi @RKGV 

Because datatype is set to date hence only taking date🙂

Hope this helps : )