Counting The Number Of Extra People Working Each Hour

Hi, I am trying to count the number of extra people scheduled for each hour of the day, from 2 dropdowns in A3:B7

The formula in (1) D11:D26 works, but when the shift passes over the midnight it will not count accurately.
The formula in (2) E11:E26 also works well, but only counts the number of times a particular hour is mentioned, but not the number of extras in C3:C7.
The results in (3) F11: F26 are what I need, which is based on looking at the times from the dropdowns and using the number of extras in C3:C7.

Any help would be greatly appreciated.

In B5, 3:00 is typed . If you select same from dropdown list, column D & E work perfectly. What you want in F column is not clear to me.

School boy error!!
Many thanks for helping, easy when it is pointed out, even thought I had checked that part.

Thanks again.....kvsrinivasamurthy