Hi

Use a Pivot Table
Insert a header row with Day, Reason and Time in A1:C1
Place cursor in A1DataPivot TableFinish
On the new sheet that is created, in the PT skeleton
Drag Day to the Column area
Drag Reason to the row area
Drag Time to the data area
Double click on TimeSelect Sum Click Numberchange format to Custom[h]:mm

--
Regards
Roger Govier

"kevcar40" wrote in message
...
Hi
I have 3 columns of data
A = day of the week
B = Fault that occurred
C = Time

ie
A B C
Mon Snapped 0:1:00
Mon Snapped 0:1:00
Tue Snapped 0:1:00

What i want to do is

Sum the time for each fault depend on the day

Result is
Mon Snapped 0:2:00
Tue Snapped 0:1:00


i was thinking of sumif or sumproduct
What is the best way of doing this please

Thanks
kevin