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.
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!
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.
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!