I have, for me, a very complicated scenario and I am hoping someone can help.
I need to populate a table with the total number of work hours a person is
responsible for on a given day. For example, I need to return the total
number of work hours for Jones on 6/3/2008. My data looks like this:

Task Name Work Hours Start Date End Date
1 Jones 2 6/2/2008 6/13/2008
2 Smith 1 5/26/2008 6/30/2008
3 Smith 0.5 6/4/2008 6/6/2008
4 Jones 5 5/30/2008 6/12/2008
5 Jones 0.5 6/9/2008 6/18/2008