DoomBlasZt
New Member
- Joined
- May 5, 2017
- Messages
- 10
I have 2 data sets :
1. Data order
<colgroup><col><col><col></colgroup><tbody>
</tbody>
2. Data schedule
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Is there any formula to find how many AAA product was ordered on time schedule? The answer should be 9
Thanks
1. Data order
Product | Order Time | Qty |
AAA | 1:30 AM | 1 |
AAA | 2:00 AM | 1 |
AAA | 2:15 AM | 1 |
AAA | 2:15 AM | 1 |
AAA | 2:15 AM | 1 |
AAA | 2:15 AM | 1 |
AAA | 2:30 AM | 1 |
AAA | 2:30 AM | 1 |
AAA | 2:30 AM | 1 |
AAA | 2:45 AM | 1 |
AAA | 3:00 AM | 1 |
AAA | 3:00 AM | 1 |
AAA | 3:00 AM | 1 |
BBB | 3:15 AM | 1 |
BBB | 3:30 AM | 1 |
BBB | 3:45 AM | 1 |
BBB | 3:45 AM | 1 |
BBB | 4:00 AM | 1 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
2. Data schedule
Product | Start | End | Duration |
AAA | 2:00 | 2:45 | 45 |
BBB | 3:00 | 4:00 | 60 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Is there any formula to find how many AAA product was ordered on time schedule? The answer should be 9
Thanks