OK, I'm going to cheat a little here since I'm rusty. Assuming you have

headers for your columns in row 1, you can:

1) Sort the 3 columns,, first by name ascending, then by date ascending

2) Insert this formula into D2 and copy down as far as you need to:

=IF(A2=A1,B2+D1,B2)

3) Now next to your name list, starting in H2, insert this and press

ctrl+shift+enter:

=INDEX($C$2:$C$50,MIN(IF((G2=$A$2:$A$50)*($D$2:$D$50>=$E$1),ROW($A$2:$A$50)-1)))

and copy down. The formula will bomb out if a person's total hours never

reach the the point in E1. Change the "50" in the formula to the last row

number in your columns that contains data.

HTH

Jason

Atlanta, GA