Scheduling Workdays with Half Days

[MrCameronExcel]

I would like to schedule workdays, but the WORKDAY formula I was using didn't capture half days.

In columns B-I is confirmation of whether or not work is required. 1 = work required, 0 = no work required.

All the start dates in column J (Large Lounge dated) are accurate and will remain. There can only be four rooms with the same date, and the priority is from top left to bottom right (Flat 1 Large Lounge - Flat 4 WC), but work must be spread across two flats, hence you see flat 1 and 2 work is carried out alongside each other (more or less).

I am using half days to make the formula work so Flat 4 Large Lounge is 18/01/2023 + 0.5 (following on from Flat 2 Bathroom 18/01/2023). This is verified in the TEST column where Flat 4 Small Lounge +0.5 = 19/01/2023.

But when I use the following formula in Flat 4 Small Lounge, it doesn't account for the half day. I need a way to get around this. I am thinking about trying to use a WEEKDAY formula in some way instead of WORKDAY.
=IF(Flat 4 Small Lounge=1, WORKDAY(Flat 4 Large Lounge (date), 0.5, 0), "")


TABLE 1

Flat

Large Lounge

Small Lounge

Bedroom 1

Bedroom 2

Bedroom 3

Kitchen

Bathroom

WC

Large Lounge

Small Lounge

Bedroom 1

Bedroom 2

Bedroom 3

Kitchen

Bathroom

WC

TEST

1​

1​

1​

1​

1​

1​

1​

0​

0​

16/01/2023​

16/01/2023​

17/01/2023​

17/01/2023​

18/01/2023​

18/01/2023​

2​

1​

1​

1​

0​

0​

1​

1​

0​

16/01/2023​

16/01/2023​

17/01/2023​

17/01/2023​

18/01/2023​

3​

1​

0​

0​

0​

0​

1​

1​

0​

19/01/2023​

19/01/2023​

20/01/2023​

4​

1​

1​

1​

1​

0​

1​

1​

1​

18/01/2023​

18/01/2023​

19/01/2023​

19/01/2023​

20/01/2023​

20/01/2023​

23/01/2023​

19/01/2023​

Have been playing around with formula below and similar without luck yet.

=IF(F5=0,"", IF(AND(F5=1,WEEKDAY(N5+0.5)=7),N5+2.5,N5+0.5))