I have a table that contains names that have a time, category, the number of
times that the name uses the category, and the total time the name uses the
category. What I want to do is get the total time for each category? There
are about 3000 names and 10 categories.

name A 5:00 category A 20 1:40:00
name B 3:30 category B 10 0:35:00
name C 4:21 category A 9 0:39:09
name D 4:49 category A 17 1:21:53

catagory A 46 ??:??:??
catagory B 10 0:35:00