Thread: summing time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kevcar40 kevcar40 is offline
external usenet poster
 
Posts: 78
Default summing time

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