7777,
Assume that you have the type in colum B and the corresponding hours in column C and there are 10 rows of data from row 2 - 11. Then you can use the SUMPRODUCT function to calculate the numbers for each type:
Put the type name in cell A12
Put this formula in A13:
=SUMPRODUCT((B2:B11=A12)*C2:C11)
HTH
EG