24 Hour Bar Chart

[emmceevee]

Hi,

I've got a spreadsheet containing time information recording when a species has been spotted being active during the day. Something like this but with obviously many more values:

Badger 23:00
Badger 23:26
Badger 02:04
Badger 06:49
Badger 03:27
Badger 04:32

I'm trying to create a bar chart with each bar accounting for how many times a species was recorded within each hour. How do I go about doing this could anyone tell me? I've been looking at how to round time to the nearest hour but most seem to be for round up e.g. 10:33am would be placed in the 11am bracket which is not what I want.


Any help is greatly appreciated!

[BadlySpelledBuoy]

Have a look at the attached for one way of doing this. Any good to you?

The table that drives the chart can be created on a hidden sheet for neatness purposes.

BSB.

[emmceevee]

Fantastic!

Thank you so much!

[BadlySpelledBuoy]

No worries. Happy to help.

Thanks for the rep point and don't forget to mark the thread as SOLVED if you're happy you have a working solution.

Take care.

BSB.