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?
<colgroup><col></colgroup><tbody>
</tbody>
Any help gratefully received!
Thx,
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,