If u have Project-names i Sheet1 column A
And Hour in Sheet1 column B (put in as times fx. 2:15)

in Sheet2 A2 copy down to row 1000

=IF(COUNTIF(Sheet1!A2:$A$1000,Sheet1!A2)=1,Sheet1! A2,"")
-------------------------------------------------------------------------------
if u have to edit this formula, do it before copying down !
in Sheet2 B2 copy down to row 1000,- while still selected CTRL+SHIFT+ENTER

=IF(ISERR(SMALL(IF(A2:A1000<"",ROW(INDIRECT("1:"& ROWS(A2:A1000)))),ROW(INDIRECT("1:"&ROWS(A2:A1000) )))),"",INDEX(A2:A1000,SMALL(IF(A2:A1000<"",ROW(I NDIRECT("1:"&ROWS(A2:A1000)))),ROW(INDIRECT("1:"&R OWS(A2:A1000))))))
------------------------------------------------------------------------------
in Sheet2 C2 copy down to row 1000

=IF(B2="","",COUNTIF(Sheet1!A2:A1000,Sheet2!B2,She et1!B2:B37))
Custumformat [h]:mm