Progress Bar Based Upon Hours + Calculate Partial and Full Day Hours

Hi,
Please, I am a bit confused, is this for the CONTRACTOR or the EMPLOYEES?
Because there is a drop-down menu that shows the OFF days when selecting an employee.

Excel 2016 (Windows) 64 bit

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT
5	Weekday/Month	SUN	MON	TUE	WED	THU	FRI	SAT	SUN	MON	TUE	WED	THU	FRI	SAT	SUN	MON	TUE	WED	THU	FRI	SAT	SUN	MON	TUE	WED	THU	FRI	SAT	SUN	MON	TUE	WED	THU	FRI	SAT	SUN	MON	TUE	WED	THU 2	FRI	SAT
6	January		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	1	2	3
7	February					1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	1	2

Sheet: 2024 Calendar View

For example, when I picked Brittany it shows these days OFF, so what do you want to do with the shown results?
Do you mean a progress bar at the far right of the table?
in that range I mean? AT6:AT17