Visualise/graph a list of time/dates

[ficklelife]

I have a list of date/times like so:

17/09/2012 05:16:26 PM
17/09/2012 05:16:34 PM
17/09/2012 05:54:15 PM
17/09/2012 05:54:16 PM
17/09/2012 05:54:55 PM
17/09/2012 06:29:53 PM
17/09/2012 06:48:58 PM
17/09/2012 07:13:01 PM
17/09/2012 07:39:46 PM
17/09/2012 08:53:51 PM
17/09/2012 09:04:41 PM
17/09/2012 09:04:49 PM
17/09/2012 10:16:11 PM
17/09/2012 10:16:14 PM
18/09/2012 12:35:57 AM
18/09/2012 01:07:41 AM
18/09/2012 04:31:13 AM
18/09/2012 04:55:39 AM
18/09/2012 06:30:21 AM
18/09/2012 06:38:25 AM
18/09/2012 06:38:28 AM
18/09/2012 07:02:46 AM
18/09/2012 07:06:00 AM
18/09/2012 07:06:01 AM

I would like to format these into a line graph, so I can see what time of each day was the busiest. I would imagine I'd split these up into hour intervals, for about 2 weeks. I've googled high and low, can anyone point me in the right direction to plotting these into a line graph?

Thanks

[jake.masters]

I would recommend using the =HOUR() function to drop the dates, then place these hours into bins using =FREQUENCY(). You can then plot the histogram from this.

Check out:
http://www.youtube.com/watch?v=RyxPp22x9PU

[ficklelife]

Great thanks for that, managed to get something resembling what I need! Cheers.