One column diagram

[Bus nerd]

Hi!

Have roughly 2200 times (hh:mm) which I need to plot in a diagram, as to how often a certain time appears. Help...

 

[steve the fish]

Hi. Do you mean create a chart? If so I thing you will need to create interval data (count of number of entries between say 00:00 and 00:59, 01:00 and 01:59 etc). That will show the most 'popular' hour. Is that what you mean?

 

[Bus nerd]

Absolutely a chart. The problem is that I need the frequency of every single minute, preferrably with a line or bar for just that minute...

 

[steve the fish]

So you just want a count of how many times say 12:00 appears? Try this. Place your 2000 times in column A. Type 12:00 in C1. Then use this formula to create a count:

=COUNTIF(A:A,C1)