Auto Fill Based On Hours Remaining

[ExcelRoy]

Hi

Can I please ask for some assistance on the following

I have a workbook that is auto updated with column F having an "Hours Remaining" field

Columns H-DD have a daily calendar associated

Now based on 8 hours a day is there a way to CF an auto fill based on the remaining hours to highlight what hours remain on each line?

Not sure if this is clear, hope so

many thanks

 

[ExcelRoy]

Hi,

Was thinking that the hours per day as listed below can be used in the calculation?

8.00​

8.00​

8.00​

8.00​

7.50​

8.00​

8.00​

8.00​

8.00​

7.50​

8.00​

8.00​

8.00​

8.00​

7.50​

M

T

W

T

F

S

S

M

T

W

T

F

S

S

M

T

W

T

F

Estimated

Taken

Balance

Percentage

14/09/2022

15/09/2022

16/09/2022

17/09/2022

18/09/2022

19/09/2022

20/09/2022

21/09/2022

22/09/2022

23/09/2022

24/09/2022

25/09/2022

26/09/2022

27/09/2022

28/09/2022

29/09/2022

30/09/2022

01/10/2022

02/10/2022

BB1

100.00

80.00

20.00

80%

CDA4

40.00

5.00

35.00

13%

BB2

65.00

0.00

65.00

0%