How to populate column from another column

[ramielm]

Hello everyone. I need help on how to calculate the elapsed time or populate the column B with the record from column A for particular person's activity; see the data below.

[TABLE="width: 477"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Date Time
[/TD]
[TD]Date Time2[/TD]
[TD]User[/TD]
[TD]Container[/TD]
[/TR]
[TR]
[TD]2017-10-03 09:34
[/TD]
[TD]
[/TD]
[TD]AHALIDU[/TD]
[TD]9371431163[/TD]
[/TR]
[TR]
[TD]2017-10-03 09:34[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431162[/TD]
[/TR]
[TR]
[TD]2017-10-03 09:47[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431397[/TD]
[/TR]
[TR]
[TD]2017-10-03 09:50[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431453[/TD]
[/TR]
[TR]
[TD]2017-10-03 09:54[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431244[/TD]
[/TR]
[TR]
[TD]2017-10-03 09:59[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431556[/TD]
[/TR]
[TR]
[TD]2017-10-03 10:17[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431239[/TD]
[/TR]
[TR]
[TD]2017-10-03 10:17[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431240[/TD]
[/TR]
[TR]
[TD]2017-10-03 10:20[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431670[/TD]
[/TR]
[TR]
[TD]2017-10-03 10:23[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431671[/TD]
[/TR]
[TR]
[TD]2017-10-03 10:57[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431366[/TD]
[/TR]
[TR]
[TD]2017-10-03 10:57[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431365[/TD]
[/TR]
[TR]
[TD]2017-10-03 11:21[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431369[/TD]
[/TR]
[TR]
[TD]2017-10-03 11:21[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431370[/TD]
[/TR]
[TR]
[TD]2017-10-03 12:05[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431276[/TD]
[/TR]
[TR]
[TD]2017-10-03 12:05[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431277[/TD]
[/TR]
[TR]
[TD]2017-10-03 12:16[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431802[/TD]
[/TR]
[TR]
[TD]2017-10-03 13:39[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431687[/TD]
[/TR]
[TR]
[TD]2017-10-03 13:39[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431686[/TD]
[/TR]
[TR]
[TD]2017-10-03 14:47[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431299[/TD]
[/TR]
[TR]
[TD]2017-10-03 14:47[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431300
[/TD]
[/TR]
[TR]
[TD]2017-10-03 14:59[/TD]
[TD]
[/TD]
[TD]AHALIDU[/TD]
[TD]9371431926[/TD]
[/TR]
[TR]
[TD]2017-10-03 15:27[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431927[/TD]
[/TR]
[TR]
[TD]2017-10-03 15:38
[/TD]
[TD]
[/TD]
[TD]AHALIDU[/TD]
[TD]9371431732[/TD]
[/TR]
[TR]
[TD]2017-10-03 15:38[/TD]
[TD]
[/TD]
[TD]AHALIDU[/TD]
[TD]9371431723[/TD]
[/TR]
[TR]
[TD]2017-10-03 15:43[/TD]
[TD] [/TD]
[TD]AHALIDU[/TD]
[TD]9371431935
[/TD]
[/TR]
</tbody>[/TABLE]

 

[lhartono]

From your calculation result would be 06:09?

 

[ramielm]

lhartono - Sorry if I explain it wrongly but if it is possible to populate the "Date Time2" field with the data from "Date Time"... it copies from the 2nd transaction onwards??


[TABLE="width: 455"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Date Time[/TD]
[TD]Date Time2[/TD]
[TD]User[/TD]
[TD]Container[/TD]
[/TR]
[TR]
[TD]10/3/2017 9:34[/TD]
[TD]10/3/2017 9:34[/TD]
[TD]AHALIDU[/TD]
[TD]9371431163[/TD]
[/TR]
[TR]
[TD]10/3/2017 9:34[/TD]
[TD]10/3/2017 9:47[/TD]
[TD]AHALIDU[/TD]
[TD]9371431162[/TD]
[/TR]
[TR]
[TD]10/3/2017 9:47[/TD]
[TD]10/3/2017 9:50[/TD]
[TD]AHALIDU[/TD]
[TD]9371431397[/TD]
[/TR]
[TR]
[TD]10/3/2017 9:50[/TD]
[TD]10/3/2017 9:54[/TD]
[TD]AHALIDU[/TD]
[TD]9371431453[/TD]
[/TR]
[TR]
[TD]10/3/2017 9:54[/TD]
[TD]10/3/2017 9:59[/TD]
[TD]AHALIDU[/TD]
[TD]9371431244[/TD]
[/TR]
[TR]
[TD]10/3/2017 9:59[/TD]
[TD]10/3/2017 10:17[/TD]
[TD]AHALIDU[/TD]
[TD]9371431556[/TD]
[/TR]
[TR]
[TD]10/3/2017 10:17[/TD]
[TD]10/3/2017 10:17[/TD]
[TD]AHALIDU[/TD]
[TD]9371431239[/TD]
[/TR]
[TR]
[TD]10/3/2017 10:17[/TD]
[TD]10/3/2017 10:20[/TD]
[TD]AHALIDU[/TD]
[TD]9371431240[/TD]
[/TR]
[TR]
[TD]10/3/2017 10:20[/TD]
[TD]10/3/2017 10:23[/TD]
[TD]AHALIDU[/TD]
[TD]9371431670[/TD]
[/TR]
[TR]
[TD]10/3/2017 10:23[/TD]
[TD]10/3/2017 10:57[/TD]
[TD]AHALIDU[/TD]
[TD]9371431671[/TD]
[/TR]
[TR]
[TD]10/3/2017 10:57[/TD]
[TD]10/3/2017 10:57[/TD]
[TD]AHALIDU[/TD]
[TD]9371431366[/TD]
[/TR]
[TR]
[TD]10/3/2017 10:57[/TD]
[TD]10/3/2017 11:21[/TD]
[TD]AHALIDU[/TD]
[TD]9371431365[/TD]
[/TR]
[TR]
[TD]10/3/2017 11:21[/TD]
[TD]10/3/2017 11:21[/TD]
[TD]AHALIDU[/TD]
[TD]9371431369[/TD]
[/TR]
[TR]
[TD]10/3/2017 11:21[/TD]
[TD]10/3/2017 12:05[/TD]
[TD]AHALIDU[/TD]
[TD]9371431370[/TD]
[/TR]
[TR]
[TD]10/3/2017 12:05[/TD]
[TD]10/3/2017 12:05[/TD]
[TD]AHALIDU[/TD]
[TD]9371431276[/TD]
[/TR]
[TR]
[TD]10/3/2017 12:05[/TD]
[TD]10/3/2017 12:16[/TD]
[TD]AHALIDU[/TD]
[TD]9371431277[/TD]
[/TR]
[TR]
[TD]10/3/2017 12:16[/TD]
[TD]10/3/2017 13:39[/TD]
[TD]AHALIDU[/TD]
[TD]9371431802[/TD]
[/TR]
[TR]
[TD]10/3/2017 13:39[/TD]
[TD]10/3/2017 13:39[/TD]
[TD]AHALIDU[/TD]
[TD]9371431687[/TD]
[/TR]
[TR]
[TD]10/3/2017 13:39[/TD]
[TD]10/3/2017 14:47[/TD]
[TD]AHALIDU[/TD]
[TD]9371431686[/TD]
[/TR]
[TR]
[TD]10/3/2017 14:47[/TD]
[TD]10/3/2017 14:47[/TD]
[TD]AHALIDU[/TD]
[TD]9371431299[/TD]
[/TR]
[TR]
[TD]10/3/2017 14:47[/TD]
[TD]10/3/2017 14:59[/TD]
[TD]AHALIDU[/TD]
[TD]9371431300[/TD]
[/TR]
[TR]
[TD]10/3/2017 14:59[/TD]
[TD]10/3/2017 15:27[/TD]
[TD]AHALIDU[/TD]
[TD]9371431926[/TD]
[/TR]
[TR]
[TD]10/3/2017 15:27[/TD]
[TD]10/3/2017 15:38[/TD]
[TD]AHALIDU[/TD]
[TD]9371431927[/TD]
[/TR]
[TR]
[TD]10/3/2017 15:38[/TD]
[TD]10/3/2017 15:38[/TD]
[TD]AHALIDU[/TD]
[TD]9371431732[/TD]
[/TR]
[TR]
[TD]10/3/2017 15:38[/TD]
[TD]10/3/2017 15:43[/TD]
[TD]AHALIDU[/TD]
[TD]9371431723[/TD]
[/TR]
[TR]
[TD]10/3/2017 15:43[/TD]
[TD]10/3/2017 15:43[/TD]
[TD]AHALIDU[/TD]
[TD]9371431935[/TD]
[/TR]
</tbody>[/TABLE]

 

[lhartono]

Try this formula on "Date Time2" column...

=A2+IF(A3-A2>=0,A3-A2,0)

 

[ramielm]

it did work!!! Thank you so much Lhartono.

 

[lhartono]

You are welcome...