summing time

[kevcar40]

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

 

[akphidelt]

Heres one way... choose a section where you want the results.

Create a column of the days like

Mon
Tue
Wed
etc

Then in the cell next to Monday put the formula
=SUMIF($A$1:$A$3,E1,$C$1:$C$3)

Remember this is assuming that the word "Mon" is in cell E1. Make sure you
leave the $ signs in the code except for on the E1 part. Then copy this code
and paste it down throughout the days of the week. Adjust it to fit your data.

Hope this helps

 

[Roger Govier]

Hi

Use a Pivot Table
Insert a header row with Day, Reason and Time in A1:C1
Place cursor in A1>Data>Pivot Table>>Finish
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 Time>Select Sum >Click Number>change format to Custom>[h]:mm