Creating a bar chart based on time groupings

[tpaman1975]

I am sure this might be simple for some but it is escaping me.
I have a column of time data formatted h:mm:ss and I would like to make a bar chart

y axis would have time groupings like:

less than a minute
1-2 minutes
2-3 minutes
3-4 minutes
4-5 minutes
5-10 minutes
Over 10 minutes

x axis would have the bar with the number fitting into that timeframe.

Any help you could give would be greatly appreciated

 

[kevin9999]

If you're asking how to create the data source for such a chart, the demo below should point you in the right direction.

Book1
	A	B	C	D
1	Values		Range	Total
2	00:02:00		Over 10 mins	7
3	00:01:00		5-10 mins	8
4	00:02:30		4-5 mins	3
5	00:03:15		3-4 mins	8
6	00:04:05		2-3 mins	4
7	00:07:00		1-2 mins	4
8	00:15:00		Less than 1 min	12
9	00:15:00
10	00:02:00
11	00:00:55
12	00:00:55
13	00:00:55
14	00:00:55
15	00:00:55
16	00:00:55
17	00:00:55
18	00:00:55
19	00:00:55
20	00:00:55
21	00:00:55
22	00:00:55
23	00:01:00
24	00:15:00
25	00:15:00
26	00:15:00
27	00:04:05
28	00:04:05
29	00:15:00
30	00:02:30
31	00:02:30
32	00:02:30
33	00:15:00
34	00:03:15
35	00:03:15
36	00:03:15
37	00:03:15
38	00:03:15
39	00:03:15
40	00:03:15
41	00:07:00
42	00:07:00
43	00:07:00
44	00:07:00
45	00:07:00
46	00:07:00
47	00:07:00
Sheet1

Cell Formulas
Range	Formula
D2	D2	=COUNTIF($A$2:$A$47,">00:10:00")
D3	D3	=COUNTIFS($A$2:$A$47,">00:05:00",$A$2:$A$47,"<=00:10:00")
D4	D4	=COUNTIFS($A$2:$A$47,">00:04:00",$A$2:$A$47,"<=00:05:00")
D5	D5	=COUNTIFS($A$2:$A$47,">00:03:00",$A$2:$A$47,"<=00:04:00")
D6	D6	=COUNTIFS($A$2:$A$47,">00:02:00",$A$2:$A$47,"<=00:03:00")
D7	D7	=COUNTIFS($A$2:$A$47,">=00:01:00",$A$2:$A$47,"<=00:02:00")
D8	D8	=COUNTIF($A$2:$A$47,"<00:01:00")

You can then use (in this demo) the range C1:D8 as your source data to create a bar graph similar to that below: