Calculate inactive time between two dates

Hi members,

I would like to request your help...

I have the following information and I would like to calculate the inactive time between two dates, for example:

I have a store with the following operating hours: 8 Hrs. to 20 Hrs, Monday to Saturday. This is an active time.

I need to calculate the inactive time, assuming that inactive time is all the time out of the previous period mentioned.

Example:

BOOS_TS_OOS -> Start the operation time

BOOS_TS_OOSReset -> Ends the operation time

If I calculate the total time between these two dates I would have to subtract the inactive time (Sunday and when it is closed 21Hrs to 7 Hrs).

I hope my explanation is clear.

Any idea that I can implement?

BOOS_BOOS_Identnr	BOOS_TS_OOS	BOOS_TS_OOSReset	BOOS_Facing
1527	08/10/2018 15:13	08/10/2018 15:13	1
1528	08/10/2018 15:13	08/10/2018 15:18	1
1529	08/10/2018 15:19	08/10/2018 15:19	1
1530	08/10/2018 15:19	08/10/2018 15:19	1
1531	08/10/2018 15:19	08/10/2018 15:19	1
1532	08/10/2018 15:20	08/10/2018 15:23	1
1533	08/10/2018 15:23	08/10/2018 15:51	1
1534	08/10/2018 15:51	08/10/2018 15:52	1
1535	08/10/2018 15:52	17/10/2018 13:18	1
1537	08/10/2018 15:53	25/10/2018 09:51	2
1538	08/10/2018 16:03	08/10/2018 16:03	3
1539	08/10/2018 16:03	25/10/2018 09:51	3
1540	08/10/2018 16:03	08/10/2018 16:03	4
1542	08/10/2018 16:03	25/10/2018 10:43	4
1543	08/10/2018 16:04	08/10/2018 16:04	5
1545	08/10/2018 16:04	25/10/2018 09:51	5
1546	08/10/2018 16:04	08/10/2018 16:04	6
1548	08