How to create a chart in excel when there is a list of applications?

Question

infographics

There is a list of data in this format
18:20
19:30
17:40
20:48
17:47
19:56
15:45
Etc.
This is a list of times at which there were applications on the site. Each line - 1 application. The lines are in chronological order.
Please tell me how to make a chart in Excel so that a graph is visible to understand what time people send applications more often.

Answer 1

Divide the day into 24 hours and count the number in each hour. In a simple way - add 24 columns with the formula if to each order, the numbering of the columns. =IF(AND($A1>=TIME(B$8;0;0);$A1<=TIME(B$8;59;59));1;0)
in cell A1 is the time of the first order, in cell B8 is the number hours - first copy the formula horizontally to all 24 columns, then vertically to all orders
If the time is in the interval then 1 otherwise 0 and then calculate the sum of units for each hour.

Answer 2

Option 1: Answer Alexander
Option 2 ( gives a great opportunity for analytics, for example, broken down by days or days of the week ): make a pivot table, and then a pivot chart for it.
Below is an example of a pivot table.
Of the benefits:
- wider functionality for analytics
- no need to write formulas
But I repeat - both options are working.