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:mad:


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

--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=553829