In the attached are two offerings, the first on Sheet1 very similar to NBVC's solution except without the x24. This gives results in days (although formatted to show hours and minutes with [hh]:mm formattting). So the CountIfs use days too. eg.:
=COUNTIFS($A$2:$A$22,$H3,$E$2:$E$22,">1.5",$E$2:$E $22,"<=2")

On Sheet2 is a pivot table solution, with an added column F to categorise each row into your 4 groups using index/match and a little table. The downside is that the pivot table won't show the groups if there are no members (there are no >24<36 or >48 in your data).

Attached Files

MSOfficeForums38761csvmtd.xlsx (16.8 KB, 12 views)