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:00
for each of the values in the "Key" column. In other words, how many
"hips" had "Difference" values that were <1:00.
I'm sure there is a formula to do this but it's one of those things
that if you don't know the answer you can't ask the right question.
Thanks in advance for any help!
Mike
--
burnsbyrne
------------------------------------------------------------------------
burnsbyrne's Profile:
http://www.excelforum.com/member.php...o&userid=22153
View this thread:
http://www.excelforum.com/showthread...hreadid=564329