Count if and Sumproduct

[Brento]

Hi,

I have been tring to write this formular all day. I need help to writ
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 rea
if, the date and time match it should add all the entrys and fill i
the space with the number and the shift lenght is for example 5hour
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
Bren

+-------------------------------------------------------------------
|Filename: shift query.doc
|Download: http://www.excelforum.com/attachment.php?postid=4912
+-------------------------------------------------------------------

 

[VBA Noob]

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

 

[Brento]

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