So here's the what i'm trying to do...
Table A has the following information:
Column K shows the time in seconds like this:
50539
50539,1
50539,2
50539,3
...
Column L shows the same information, but with whole seconds like this:
50539
50540
50541
50542
...
Kolumn AS shows the additional info, which is calculated only to the column L. It goes like this:
0
0
0
1181
0
...
And the problem is this:
I should create a new column, where the information on the AS is keyed to same rows on K-column as they are on L-column. So if L column has 50539 on it and in the same row on AS has 0, then all the columns on K with 50539 to 50539,9 should have 0 on the same row with this newly created column. Let's call it the AT-column.
Did any of this make sense?
Table A has the following information:
Column K shows the time in seconds like this:
50539
50539,1
50539,2
50539,3
...
Column L shows the same information, but with whole seconds like this:
50539
50540
50541
50542
...
Kolumn AS shows the additional info, which is calculated only to the column L. It goes like this:
0
0
0
1181
0
...
And the problem is this:
I should create a new column, where the information on the AS is keyed to same rows on K-column as they are on L-column. So if L column has 50539 on it and in the same row on AS has 0, then all the columns on K with 50539 to 50539,9 should have 0 on the same row with this newly created column. Let's call it the AT-column.
Did any of this make sense?