Count if and Sumproduct

Hi,

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

Why don't you post as a excel attachment. Would make it easier to copy

I have tried it would allow .xls to be uploaded.