Excel - gráfica de horas excell

hola tengo los siguientes valores de horas y me gustaria sacar una grafica para para saber en que horas del dia se tiene mas mensajes es decir que en el rango de los largo del dia en que horas se tienes mas valores (mensajes)


0:06:10
0:06:49
0:07:04
0:07:37
0:08:07
0:08:19
0:08:36
0:08:46
0:42:10
0:43:03
0:57:38
0:59:06
1:08:24
1:11:42
3:54:58
3:55:38
3:55:39
3:55:40
3:55:46
3:55:58
3:56:16
4:01:41
4:02:34
4:03:06
4:03:35
4:03:53
4:05:50
4:21:23
4:21:37
4:22:06
4:24:36
4:25:21
4:49:33
4:49:48
4:50:40
4:53:38
4:54:30
4:54:55
5:17:08
9:02:37
9:02:38
9:02:39
9:18:42
9:20:28
9:26:35
10:52:04
10:52:37
10:53:07
10:53:36
10:53:44
10:53:56
10:54:35
10:56:20
11:19:04
11:20:21
11:21:17
11:22:25
11:27:37
11:27:56
11:37:43
11:38:23
11:38:56
11:39:37
13:17:42
14:25:26
14:26:16
14:26:50
14:28:12
14:28:21
14:28:54
14:29:54
14:30:40
11:30:53
11:37:44
11:37:54
11:41:01
11:44:01
11:47:29
11:47:36
11:47:54
11:48:11
11:49:29
11:51:17
11:51:17
11:52:04
11:52:31
11:54:03
11:59:19
12:00:17
12:04:38
12:07:41
12:08:02
12:08:42
12:09:34
12:18:45
12:21:13
12:21:34
12:22:43
12:30:21
12:31:50
12:32:00
12:32:16
12:34:48
12:37:03
12:37:16
12:37:40
12:38:08
15:57:56
16:03:21
16:03:39
16:05:26
16:05:44
16:08:40
16:12:37
16:29:40
11:42:35
11:42:50
11:43:25
11:43:41
11:43:52
11:44:24
11:44:49
11:48:00
11:48:07
11:48:49
11:49:49
11:51:51
11:52:54
11:53:10
11:53:17
11:53:18
11:54:40
11:55:08
11:55:26
11:55:48
11:55:48
11:55:56
11:56:32
11:56:42
11:57:30
11:59:13
12:00:50
12:01:00
12:01:09
12:03:05
12:04:43
12:04:55
12:05:08
12:05:27
12:05:32
12:06:03
12:06:14
12:06:23
12:06:48
12:07:13
12:07:24
12:07:30
11:57:20
11:57:59
11:58:49
12:07:26
12:10:31
12:10:49
12:11:08
12:11:28
12:12:18
12:13:04
12:13:27
12:17:23
12:19:39
12:20:29
12:20:33
12:21:05
12:21:25
12:23:39
12:24:01
12:25:17
12:25:47
12:26:41
12:32:21
12:32:49
12:34:10
12:34:55
12:35:27
12:36:05
12:37:00
12:37:25
12:40:42
12:50:17
12:59:21
13:08:22
13:10:45
13:36:03
13:36:21
13:36:35
13:36:38
13:46:53
13:47:25
15:51:47
16:00:00
16:00:46
16:00:50
16:06:10
16:08:28
16:09:20
16:09:29
16:10:04
16:14:15
16:30:05
17:36:51
19:39:06
19:39:40
19:40:54
19:41:41
19:47:15
19:49:05
23:37:53
23:45:30
23:45:57
23:46:40
23:46:57
23:47:39
12:36:32
12:36:59
12:37:29
12:37:50
12:38:07
12:38:21
12:38:40
12:38:54
12:39:23
12:40:28
12:40:37
12:41:33
12:41:48
12:45:05
12:45:55
12:49:04
12:53:23
12:53:30
12:53:41
12:53:47
12:54:46
18:19:22
18:19:27
18:19:28
18:19:28
18:19:29
18:19:29
18:19:30
18:19:31
18:44:55
18:46:37
18:47:13
18:47:16
18:49:04
19:08:57
19:10:26
19:10:27
19:10:44
19:29:18
19:30:59
19:31:05
19:59:12
14:42:41
14:43:01
14:43:39
14:44:25
14:44:28
14:44:49
14:44:56
14:45:25
14:45:31
14:45:50
14:46:49
14:47:57
14:49:15
14:50:00
14:50:31
14:50:35
14:51:54
14:53:13
14:53:32
14:54:21
14:56:08
14:57:23
14:58:56
15:03:07
15:06:26
15:07:00
15:07:10
15:07:16
15:07:44
15:08:52
15:09:18
15:09:46
15:13:34
15:16:14
15:18:16
15:44:26
15:55:27
15:55:33
15:56:46
15:57:23
20:10:45
20:11:02
20:13:54
16:58:15
17:02:06
17:02:43
17:03:36
18:45:55
18:46:26
18:46:38
18:49:27
18:54:06
18:56:06
19:00:40
19:02:26
19:10:21
19:12:47
19:13:33
19:17:52
19:24:52
19:25:59
19:26:45
19:29:06
19:30:27
19:34:17
19:34:51
19:43:56
19:44:47
19:45:05
20:34:26
20:50:27
21:06:13
21:06:52
21:07:21
22:49:14
23:05:29
23:09:00
23:25:42
23:30:39
23:30:47
23:31:54
23:33:20
23:33:23
23:33:32
23:35:30
23:45:49
19:11:09
19:11:29
19:11:50
19:12:24
19:12:55
19:13:04
19:16:43
19:17:01
19:17:35
19:17:55
19:18:31
19:18:40
19:18:44
19:24:30

Para este tipo de estudios, yo realizo un redondeo y después una tabla dinámica.

En mi caso con redondeo a horas es suficiente, pero quizás prefieras redondearlo a bloques de 30 o 15 minutos.

Adjunto ejemplo

• horas.zip(16,1 KB)

La mejor opción, la de GMC con Tabla dinámica.
Otras opciones son con la función frecuencia o con Datos > Análisis de datos > Estadística descriptiva o Histograma.
https://wordexperto.com/