Assigning a time to a range

[Woody1979]

Hi Guys,

I thought this would be SO easy, but my rusty excel skills and my age mean I can't quickly work out how to assign time to a time range.

If my times are in a one column and I want to know how many fall in say 4/5 different time ranges (i.e 9-12pm, 12-3, 3-5,5-7pm), would I use a COUNTIF or something similar? A pivot table is another option I guess?

12:33:34

11:45:43

13:04:32

14:28:17

14:38:43

13:05:49

13:25:12

13:46:59

14:18:36

16:02:54

15:58:53

12:01:28

<colgroup><col></colgroup><tbody>
</tbody>

Any help gratefully received!

Thx,

 

[Woody1979]

Actually a PIVOT table is what I should have done in the first place! Thx

 

[shaowu459]

for example,

B1=LOOKUP(A1,{9;12;15;17}/24-1%%%%,{"9-12pm";"12-3pm";"3-5pm";"5-7pm"})

please note: 12:00 falls to range 12-3pm