Heat map excel , hour by rang formula

[Creekleo]

Hello to all members,
I want to create a heat map in excel for sales by day and time bucket.

I want to add the time bucket like this :
if the time is 05:20:35 then i want to automatically the time bucket 4 AM - 6 AM to be added.
So overall, depending on the time i want the hour rang to be inserted. if there is any way to do it please. thank you

Sales-Analysis-Heat-Map-by-Time-and-Day.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Date	Time	Sales	Month	Day	Time Bucket				Time Bucket List
2	1-Jan-2022	05:20:35 AM	28	Jan-2022	Sat	4 AM - 6 AM
3	1-Jan-2022	05:58:10 AM	75	Jan-2022	Sat
4	1-Jan-2022	05:51:12 PM	66	Jan-2022	Sat
5	1-Jan-2022	09:40:48 AM	90	Jan-2022	Sat								Time Bucket
6	1-Jan-2022	01:19:00 PM	20	Jan-2022	Sat					12:00 AM	2:00 AM		12 AM - 2 AM
7	1-Jan-2022	12:36:03 AM	57	Jan-2022	Sat					2:00 AM	4:00 AM		2 AM - 4 AM
8	1-Jan-2022	06:50:31 PM	86	Jan-2022	Sat					4:00 AM	6:00 AM		4 AM - 6 AM
9	1-Jan-2022	01:20:48 AM	48	Jan-2022	Sat					6:00 AM	8:00 AM		6 AM - 8 AM
10	1-Jan-2022	06:43:08 AM	86	Jan-2022	Sat					8:00 AM	10:00 AM		8 AM - 10 AM
11	1-Jan-2022	12:40:50 PM	65	Jan-2022	Sat					10:00 AM	12:00 PM		10 AM - 12 PM
12	2-Jan-2022	06:52:06 PM	78	Jan-2022	Sun					12:00 PM	2:00 PM		12 PM - 2 PM
13	2-Jan-2022	03:44:50 PM	54	Jan-2022	Sun					2:00 PM	4:00 PM		2 PM - 4 PM
14	2-Jan-2022	11:20:58 PM	57	Jan-2022	Sun					4:00 PM	6:00 PM		4 PM - 6 PM
15	2-Jan-2022	04:34:24 PM	73	Jan-2022	Sun
16	2-Jan-2022	09:21:16 AM	30	Jan-2022	Sun
17	2-Jan-2022	06:35:41 PM	80	Jan-2022	Sun
18	2-Jan-2022	12:35:56 AM	53	Jan-2022	Sun
19	2-Jan-2022	12:00:12 AM	82	Jan-2022	Sun
20	2-Jan-2022	09:12:06 AM	43	Jan-2022	Sun
21	2-Jan-2022	06:31:11 AM	60	Jan-2022	Sun
22	2-Jan-2022	12:50:17 AM	90	Jan-2022	Sun
23	2-Jan-2022	10:49:05 PM	71	Jan-2022	Sun
24	2-Jan-2022	11:45:54 AM	57	Jan-2022	Sun
25	2-Jan-2022	09:14:04 PM	62	Jan-2022	Sun
26	3-Jan-2022	06:20:21 PM	82	Jan-2022	Mon
27	3-Jan-2022	08:23:59 PM	86	Jan-2022	Mon
28	3-Jan-2022	04:17:04 AM	32	Jan-2022	Mon
29	3-Jan-2022	05:53:19 PM	66	Jan-2022	Mon
30	3-Jan-2022	10:30:47 PM	82	Jan-2022	Mon
31	4-Jan-2022	10:37:05 PM	60	Jan-2022	Tue
32	4-Jan-2022	02:07:44 PM	60	Jan-2022	Tue
33	4-Jan-2022	05:39:40 PM	85	Jan-2022	Tue
34	4-Jan-2022	08:09:10 AM	38	Jan-2022	Tue
35	4-Jan-2022	10:59:39 PM	45	Jan-2022	Tue
36	4-Jan-2022	08:18:02 AM	20	Jan-2022	Tue
37	4-Jan-2022	01:03:28 AM	34	Jan-2022	Tue
38	4-Jan-2022	08:17:48 PM	86	Jan-2022	Tue
39	4-Jan-2022	01:47:07 PM	65	Jan-2022	Tue
40	4-Jan-2022	03:03:03 PM	87	Jan-2022	Tue
41	4-Jan-2022	09:57:20 PM	43	Jan-2022	Tue
42	4-Jan-2022	02:04:41 PM	48	Jan-2022	Tue
43	4-Jan-2022	06:37:58 PM	65	Jan-2022	Tue
44	4-Jan-2022	12:20:27 PM	22	Jan-2022	Tue
45	4-Jan-2022	01:25:23 PM	51	Jan-2022	Tue
Feuil2

Cell Formulas
Range	Formula
D2:D45	D2	=TEXT([@Date],"MMM-YYYY")
E2:E45	E2	=TEXT([@Date],"DDD")