Hi,
I have been using a sumproduct formula for some years, and although it works fine I was wondering if there was an alternative way of getting the same result.
In C8 copied down =SUMPRODUCT(($A8>=$A$3:$A$4)*1,($B8<=$B$3:$B$4)*1,($C$3:$C$4)) to show how many are in each hour
<tbody>
</tbody>
I have been using a sumproduct formula for some years, and although it works fine I was wondering if there was an alternative way of getting the same result.
In C8 copied down =SUMPRODUCT(($A8>=$A$3:$A$4)*1,($B8<=$B$3:$B$4)*1,($C$3:$C$4)) to show how many are in each hour
Start | Finish | Staff |
22:00 | 04:00 | 10 |
00:00 | 06:00 | 28 |
21:00 | 22:00 | 0 |
22:00 | 23:00 | 10 |
23:00 | 00:00 | 10 |
00:00 | 01:00 | 38 |
01:00 | 02:00 | 38 |
02:00 | 03:00 | 38 |
03:00 | 04:00 | 38 |
04:00 | 05:00 | 28 |
05:00 | 06:00 | 28 |
06:00 | 07:00 | 0 |
07:00 | 08:00 | 0 |
<tbody>
</tbody>