Problem with formula for a gantt chart

[bs1977]

Evening all. I have created gantt chart in excel and it it working fine for what i need it for, but there is one formula i am struggling with. it is to generate the number of cells to highlight for my conditional formatting.

19-03-2019 20-14-45.png

Cells Columns F and G work out the cells to highlight. So F5 the amout of cells before start highlight and G5 the cell to finish highlighting.

You can see the formula in the bar that works. But i have to type the highlighted date in for it to work. is there anyway i can use a formula that will give me the same result but instead of me typing the highlighted date in everytime, will populate from Cell C5.

=ROUND((C5-DATE(2019,3,16))*24+1,0) This is the formula in the C column
=ROUND((D5-DATE(2019,3,16))*24,0) This is the formula in the D column

in red are the parts i hve to change manually to represent what is in the C or D column

Thanks

BS

[Bo_Ry]

Please try
=MOD(C5,1)*24+1

=(D5-INT(C5))*24

[bs1977]

Excellent. Thank you