Can this formula be created - Challenge

Hi All,

Please take a look at the attachement and there are examples in there.

I have been tring to write this formular all day. I need help to write the formular to do this?

attached is a file which displays what i am trying to do.

What I need the formular to do is read the info from table a to read if, the date and time match it should add all the entrys and fill in the space with the number and the shift lenght is for example 5hours from 16:00 then it should add 1 entry for 5 hours from 16:00 to 21:00.

Please help. If you require more info please post a response.
Thanks
Brent