Urgent - Calculate time between two dates but include working hours of Saturday

[sn0365]

Hello,

Can someone please help me with a formula which can help me calculate the total time in hours between two dates but exclude

the total hours starting from Saturday (13:00 hours) to end of Sunday (23:59:59).

Really appreciate your help.

regards,
sn0365

 

[GR00007]

Now	Last Sat @ 1PM (B2)	Last Sun EOD (C2)
2/8/2019 15:11	2/2/2019 13:00	2/3/19 11:59 PM
Actual Start	Actual End	Calc Start	Calc End
2/1/2019 08:00	2/2/2019 14:00	2/1/2019 08:00	2/2/2019 13:00
2/3/2019 16:00	2/4/2019 08:00	2/3/2019 23:59	2/4/2019 08:00
2/1/2019 9:00	2/1/2019 17:00	2/1/2019 09:00	2/1/2019 17:00
2/4/2019 9:00	2/4/2019 17:00	2/4/2019 09:00	2/4/2019 17:00

<tbody>
</tbody>

Calculations
B2

=FLOOR(NOW() -MOD(WEEKDAY(NOW(),1),7),1) +0.542

C2

=FLOOR(NOW() -(MOD(WEEKDAY(NOW(),1),7) -2),1) -0.0001

C4

=IF(A4 < FLOOR(NOW() -MOD(WEEKDAY(NOW(),1),7),1) +0.542,A4,IF(A4 < FLOOR(NOW() -(MOD(WEEKDAY(NOW(),1),7) -2),1) -0.0001,FLOOR(NOW() -(MOD(WEEKDAY(NOW(),1),7) -2),1) -0.0001,A4))

D4

=IF(B4 >FLOOR(NOW() -(MOD(WEEKDAY(NOW(),1),7) -2),1) -0.0001,B4,IF(B4>FLOOR(NOW() -MOD(WEEKDAY(NOW(),1),7),1) +0.542,FLOOR(NOW() -MOD(WEEKDAY(NOW(),1),7),1) +0.542,B4))

C4 & D4 were copied down
To get the difference use D4 - C4 which will give the result in daytime which can be formatted in hours