Using Time values for SUMIF Function

Hi there,

I'm pretty new to excel and am working on a sheet to track how much time was spent per item from list.

I work at a call center and I am trying to track the amount of time spent in each phone state.

Whenever i use the SUMIF function the result is always 0 because the data is a time and not a number. If i change the time to a number it calculates it correctly but won't do it if its a time.

I have created a drop down list for the states (B Column), and have it calculating the amount of time spent in each state (C Column). I just need it to total the time spent in each state (F Column)

The formula in C2 returns a text value, which is producing the zeros. Change the formula in C2 to this:

=IF(A3="",0,SUM(A3-A2))

Apply a Custom Format of [h]:mm:ss to that cell, then copy down as far as you need to. Then you can change the formula in F2 to this:

=SUMIF($B$2:$B$500, E2,$C$2:$C$500)

Again, apply a Custom Format of [h]:mm:ss to that cell, then copy down.

Hope this helps.

Pete