Calculation based on 2 cols

[burnsbyrne]

I have a file that looks like this

Key ATB Time: Start: Difference
hip 8:22 8:49 0:27
Knee 15:15 15:40 0:25
cabg 12:35 12:58 0:23
etc.

Difference equals (Start) - (ATB Time)
Values of the columns are hour:minute

I need to count how many of the "Difference" values are less than 1:0
for each of the values in the "Key" column. In other words, how man
"hips" had "Difference" values that were <1:00.

I'm sure there is a formula to do this but it's one of those thing
that if you don't know the answer you can't ask the right question.

Thanks in advance for any help!

Mik

 

[Vincnet.]

Par exemple :
=SOMMEPROD((A2:A7="hip")*(D27<TEMPS(1;0;0)))

 

[Sloth]

En Englais si vous plait

=SUMPRODUCT((A2:A4="hip")*(D24<1/24))
or
=SUMPRODUCT((A2:A4="hip")*(D24<TIME(1,0,0)))

I'm just kidding about the language. It took me a second to figure out what
formulas you were using.

Par exemple :
=SOMMEPROD((A2:A7="hip")*(D27<TEMPS(1;0;0)))