Labour utilisation in Excel calendar

[kapi98]

Hi guys,

This post is slightly related to my previous post. I was wondering how I could link the available labour hours with my scheduling table. I've got the number hours available for departments a day.

Sample.xlsm
	O	P	Q	R	S
27	Mon 14	Tue 15	Wed 16	Thu 17	Fri 18
28	8	8	16	16	16
29	24	32	32	32	32
30	16	16	16	16	16
31	8	8	8	8	8
Sheet3

Cell Formulas
Range	Formula
O27:S27	O27	=N27+1
O28:S28	O28	=IF(SUM(O8:O10)=0,"",SUM(O8:O10))
O29:S29	O29	=IF(SUM(O12:O16)=0,"",SUM(O12:O16))
O30:S30	O30	=IF(SUM(O18:O20)=0,"",SUM(O18:O20))
O31:S31	O31	=IF(SUM(O22:O23)=0,"",SUM(O22:O23))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B27:AF31	Expression	=WEEKDAY(B$6,2)>5	text	NO

For example, Job 3 is going to take 24 hours or 3 business days. However I've got 16 hours of labour available over these days, so it should be completed in just 1.5 days.

Is there a way to link it these sheets together? Also, it'd be great to see like a calendar with scheduled jobs on them. I've tried to play around with conditional formatting but it doesn't work correctly.

Please advice if you could see a potential solution.

Thanks!