Is there a formula that can be ran on these values to then return something similar to the sample table provided below. The objective of this formula wold be to break down minute by minute is there are 0,1,2, or more times overlapping.
<colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;"><colgroup><col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"><tbody>
</tbody>
From this ^ to this (below)
<colgroup><col width="64" style="width: 48pt;" span="20">
<tbody>
</tbody>
Times | |
12:45 | 13:01 |
12:55 | 13:05 |
<colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;"><colgroup><col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"><tbody>
</tbody>
From this ^ to this (below)
12:43 | 12:44 | 12:45 | 12:46 | 12:47 | 12:48 | 12:49 | 12:50 | 12:51 | 12:52 | 12:53 | 12:54 | 12:55 | 12:56 | 12:57 | 12:58 | 12:59 | 13:00 | 13:01 | 13:02 |
0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 |