Hi there,
It's a long time since I wrote my last message. I would be grateful if somebody could help me on this issue:
I have this table with these values:
<tbody>
</tbody>
and I want to generate multiple rows based on the duration of time In and Out like below:
<tbody>
</tbody>
Any tip/help would be greatly appreciated
It's a long time since I wrote my last message. I would be grateful if somebody could help me on this issue:
I have this table with these values:
Time In | Time Out | Product ID |
00:00:10 | 00:00:13 | A |
00:00:15 | 00:00:19 | B |
00:01:20 | 00:01:21 | C |
... | ... | ... |
<tbody>
</tbody>
and I want to generate multiple rows based on the duration of time In and Out like below:
Time In | Product ID |
00:00:10 | A |
00:00:11 | A |
00:00:12 | A |
00:00:13 | A |
00:00:15 | B |
00:00:16 | B |
00:00:17 | B |
00:00:18 | B |
00:00:19 | B |
00:01:20 | C |
00:01:21 | C |
<tbody>
</tbody>
Any tip/help would be greatly appreciated