Don't know why it didn't work for me earlier <g, but here's a refinement
for the array formulae in Sheet2 which uses TIMEVALUE to convert the text
"times" returned by the INDEX(...) to real times

In Sheet2
------------

Put instead in B2, and array-enter:

=IF(ISNA(MATCH($A2&"_"&B$1,Sheet1!$A$1:$A$300&"_"& Sheet1!$L$1:$L$300,0)),"",
TIMEVALUE(INDEX(Sheet1!$G:$G,MATCH($A2&"_"&B$1,She et1!$A$1:$A$300&"_"&Sheet1
!$L$1:$L$300,0))))

Format B2 as Custom, Type: [h]:mm:ss
then copy B2 across & fill down to populate the grid, as before

Now you can sum the total time for each employee in row11,
e.g. in B11: =SUM(B2:B10)

Leave the text "dates" in col A as it is, otherwise the matching
with the source data in Sheet1 won't work

(Sheet3 could hence effectively be dispensed with)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--