Timeline help!

Hi!

I have a table containing:

• Order picklist creation time (format HHMMSS, forexample: 123109)
• Order picklist confirmed time (format HHMMSS, forexample: 132954)
If the time is less than 10:00:00, the time only has 5 numbers: Forexample if the confirmed date is 09:54:31, it will say 95431 in the table.

My goal is to make a timeline/graph that shows how many unconfirmed/open order picklists that exists at all times during the day. So a y-axis with the number of picklists, and the x-axis is the timeline/hours during the day.
If it makes it any easier, I could group it by 15 or 30 minute intervals.

I really appreciate all the help I can get!