SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Datetimes (TestSet INT, Dt DATETIME)
INSERT Datetimes
VALUES
    (1, '2022-10-31 10:30:52'), (1, '2022-11-02 23:47:55'), -- OP Test case 1
    (2, '2022-11-01 08:30:46'), (2, '2022-11-03 02:59:27'), -- OP Test case 2
    -- Various over-the weekend cases
    (3, '2023-01-01 00:00'),                          -- Sunday
    (3, '2023-12-01 08:00'), (3, '2023-12-01 16:45'), -- Friday
    (3, '2023-12-02 08:00'), (3, '2023-12-02 16:45'), -- Saturday
    (3, '2023-12-03 08:00'), (3, '2023-12-03 16:45'), -- Sunday
    (3, '2023-12-04 08:00'), (3, '2023-12-04 16:45'), -- Monday
    (3, '2023-12-31 23:59:59'),                       -- Sunday
    -- Various weekday cases
    (4, '2023-12-01 10:00:05'),                       -- Friday
    (4, '2023-12-04 11:15:10'),                       -- Monday
    (4, '2023-12-06 09:00:15'),                       -- Wednesday
    (4, '2023-12-08 15:45:20'),                       -- Friday
    (4, '2023-12-11 14:30:25');                       -- Monday

-- Populate a cross combination of start and end dates, within each test set
CREATE TABLE TestData (TestSet INT, StartDateTime DATETIME, EndDateTime DATETIME)
INSERT TestData
SELECT S.TestSet, S.Dt AS StartDateTime, E.Dt AS EndDateTime
FROM DateTimes S
JOIN DateTimes E ON E.TestSet = S.TestSet;

152 rows affected

--SET DATEFIRST 7 -- US
--SET DATEFIRST 1 -- Mostly everywhere else

-- The weekday value from DATEPART(weekday) is locale/settings dependent
-- So we need to calculate the expected values
--   For @@DateFirst = 7, @SaturdayDW = 7 and @SundayDW = 1
--   For @@DateFirst = 1, @SaturdayDW = 6 and @SundayDW = 7
--   For @@DateFirst = 6, @SaturdayDW = 1 and  @SundayDW = 2
-- DATEDIFF(week, ...) is unaffected by the DateFirst setting.
DECLARE @SaturdayDW INT = DATEPART(weekday, '20000101') -- Reference Saturday
DECLARE @SundayDW INT = DATEPART(weekday, '20000102') -- Reference Sunday
--SELECT @@DateFirst AS DateFirst, @SaturdayDW AS SaturdayDW, @SundayDW SundayDW
  
SELECT
    T.TestSet, T.StartDateTime, T.EndDateTime,
    LEFT(DATENAME(dw, T.StartDateTime), 3) AS SDay,
    LEFT(DATENAME(dw, T.EndDateTime), 3) AS EDay,
    FMT.AdjustedStart,
    FMT.AdjustedEnd,
    FMT.Elapsed
FROM TestData T
CROSS APPLY (
    -- Adjust weekend dates forward to 00:00:00 of the following Monday
    SELECT
        CASE DATEPART(dw, T.StartDateTime)
            WHEN @SaturdayDW
                THEN CONVERT(DATETIME, DATEADD(day, 2, CONVERT(DATE, T.StartDateTime)))
            WHEN @SundayDW
                THEN CONVERT(DATETIME, DATEADD(day, 1, CONVERT(DATE, T.StartDateTime)))
            ELSE T.StartDateTime
            END AS AdjStart,
        CASE DATEPART(dw, T.EndDateTime)
            WHEN @SaturdayDW
                THEN CONVERT(DATETIME, DATEADD(day, 2, CONVERT(DATE, T.EndDateTime)))
            WHEN @SundayDW
                THEN CONVERT(DATETIME, DATEADD(day, 1, CONVERT(DATE, T.EndDateTime)))
            ELSE T.EndDateTime
            END AS AdjEnd
) A
CROSS APPLY (
    -- Calculate raw differences
    SELECT
        DATEDIFF(second, AdjStart, AdjEnd) AS Seconds,
        DATEDIFF(week, AdjStart, AdjEnd) AS Weeks
) ES
CROSS APPLY (
    -- Calculate and adjust for days, calculate separate time, handle negatives
    SELECT
        CASE WHEN ES.Seconds < 0 THEN '-' ELSE '' END AS Sign,
        ABS(ES.Seconds) / 86400 - 2 * ABS(Weeks) AS Days,
        DATEADD(second, ABS(ES.Seconds) % 86400, 0) AS Time
) EP
CROSS APPLY (
    -- Format intermediate data and results
    SELECT
       CONCAT(
           EP.Sign,
           EP.Days,
           CASE WHEN EP.Days = 1 THEN ' Day, ' ELSE  ' Days, ' END,
           CONVERT(CHAR(8), EP.Time, 108)
           ) AS Elapsed,
       CONCAT(
           LEFT(DATENAME(dw, A.AdjStart), 3),
           ', ',
           CONVERT(CHAR(8), A.AdjStart, 108)
           ) AS AdjustedStart,
       CONCAT(
           LEFT(DATENAME(dw, A.AdjEnd), 3),
           ', ',
           CONVERT(CHAR(8), A.AdjEnd, 108)
           ) AS AdjustedEnd
) FMT
ORDER BY T.TestSet, T.StartDateTime, T.EndDateTime

TestSet	StartDateTime	EndDateTime	SDay	EDay	AdjustedStart	AdjustedEnd	Elapsed
1	2022-10-31 10:30:52.000	2022-10-31 10:30:52.000	Mon	Mon	Mon, 10:30:52	Mon, 10:30:52	0 Days, 00:00:00
1	2022-10-31 10:30:52.000	2022-11-02 23:47:55.000	Mon	Wed	Mon, 10:30:52	Wed, 23:47:55	2 Days, 13:17:03
1	2022-11-02 23:47:55.000	2022-10-31 10:30:52.000	Wed	Mon	Wed, 23:47:55	Mon, 10:30:52	-2 Days, 13:17:03
1	2022-11-02 23:47:55.000	2022-11-02 23:47:55.000	Wed	Wed	Wed, 23:47:55	Wed, 23:47:55	0 Days, 00:00:00
2	2022-11-01 08:30:46.000	2022-11-01 08:30:46.000	Tue	Tue	Tue, 08:30:46	Tue, 08:30:46	0 Days, 00:00:00
2	2022-11-01 08:30:46.000	2022-11-03 02:59:27.000	Tue	Thu	Tue, 08:30:46	Thu, 02:59:27	1 Day, 18:28:41
2	2022-11-03 02:59:27.000	2022-11-01 08:30:46.000	Thu	Tue	Thu, 02:59:27	Tue, 08:30:46	-1 Day, 18:28:41
2	2022-11-03 02:59:27.000	2022-11-03 02:59:27.000	Thu	Thu	Thu, 02:59:27	Thu, 02:59:27	0 Days, 00:00:00
3	2023-01-01 00:00:00.000	2023-01-01 00:00:00.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-01-01 00:00:00.000	2023-12-01 08:00:00.000	Sun	Fri	Mon, 00:00:00	Fri, 08:00:00	239 Days, 08:00:00
3	2023-01-01 00:00:00.000	2023-12-01 16:45:00.000	Sun	Fri	Mon, 00:00:00	Fri, 16:45:00	239 Days, 16:45:00
3	2023-01-01 00:00:00.000	2023-12-02 08:00:00.000	Sun	Sat	Mon, 00:00:00	Mon, 00:00:00	240 Days, 00:00:00
3	2023-01-01 00:00:00.000	2023-12-02 16:45:00.000	Sun	Sat	Mon, 00:00:00	Mon, 00:00:00	240 Days, 00:00:00
3	2023-01-01 00:00:00.000	2023-12-03 08:00:00.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	240 Days, 00:00:00
3	2023-01-01 00:00:00.000	2023-12-03 16:45:00.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	240 Days, 00:00:00
3	2023-01-01 00:00:00.000	2023-12-04 08:00:00.000	Sun	Mon	Mon, 00:00:00	Mon, 08:00:00	240 Days, 08:00:00
3	2023-01-01 00:00:00.000	2023-12-04 16:45:00.000	Sun	Mon	Mon, 00:00:00	Mon, 16:45:00	240 Days, 16:45:00
3	2023-01-01 00:00:00.000	2023-12-31 23:59:59.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	260 Days, 00:00:00
3	2023-12-01 08:00:00.000	2023-01-01 00:00:00.000	Fri	Sun	Fri, 08:00:00	Mon, 00:00:00	-239 Days, 08:00:00
3	2023-12-01 08:00:00.000	2023-12-01 08:00:00.000	Fri	Fri	Fri, 08:00:00	Fri, 08:00:00	0 Days, 00:00:00
3	2023-12-01 08:00:00.000	2023-12-01 16:45:00.000	Fri	Fri	Fri, 08:00:00	Fri, 16:45:00	0 Days, 08:45:00
3	2023-12-01 08:00:00.000	2023-12-02 08:00:00.000	Fri	Sat	Fri, 08:00:00	Mon, 00:00:00	0 Days, 16:00:00
3	2023-12-01 08:00:00.000	2023-12-02 16:45:00.000	Fri	Sat	Fri, 08:00:00	Mon, 00:00:00	0 Days, 16:00:00
3	2023-12-01 08:00:00.000	2023-12-03 08:00:00.000	Fri	Sun	Fri, 08:00:00	Mon, 00:00:00	0 Days, 16:00:00
3	2023-12-01 08:00:00.000	2023-12-03 16:45:00.000	Fri	Sun	Fri, 08:00:00	Mon, 00:00:00	0 Days, 16:00:00
3	2023-12-01 08:00:00.000	2023-12-04 08:00:00.000	Fri	Mon	Fri, 08:00:00	Mon, 08:00:00	1 Day, 00:00:00
3	2023-12-01 08:00:00.000	2023-12-04 16:45:00.000	Fri	Mon	Fri, 08:00:00	Mon, 16:45:00	1 Day, 08:45:00
3	2023-12-01 08:00:00.000	2023-12-31 23:59:59.000	Fri	Sun	Fri, 08:00:00	Mon, 00:00:00	20 Days, 16:00:00
3	2023-12-01 16:45:00.000	2023-01-01 00:00:00.000	Fri	Sun	Fri, 16:45:00	Mon, 00:00:00	-239 Days, 16:45:00
3	2023-12-01 16:45:00.000	2023-12-01 08:00:00.000	Fri	Fri	Fri, 16:45:00	Fri, 08:00:00	-0 Days, 08:45:00
3	2023-12-01 16:45:00.000	2023-12-01 16:45:00.000	Fri	Fri	Fri, 16:45:00	Fri, 16:45:00	0 Days, 00:00:00
3	2023-12-01 16:45:00.000	2023-12-02 08:00:00.000	Fri	Sat	Fri, 16:45:00	Mon, 00:00:00	0 Days, 07:15:00
3	2023-12-01 16:45:00.000	2023-12-02 16:45:00.000	Fri	Sat	Fri, 16:45:00	Mon, 00:00:00	0 Days, 07:15:00
3	2023-12-01 16:45:00.000	2023-12-03 08:00:00.000	Fri	Sun	Fri, 16:45:00	Mon, 00:00:00	0 Days, 07:15:00
3	2023-12-01 16:45:00.000	2023-12-03 16:45:00.000	Fri	Sun	Fri, 16:45:00	Mon, 00:00:00	0 Days, 07:15:00
3	2023-12-01 16:45:00.000	2023-12-04 08:00:00.000	Fri	Mon	Fri, 16:45:00	Mon, 08:00:00	0 Days, 15:15:00
3	2023-12-01 16:45:00.000	2023-12-04 16:45:00.000	Fri	Mon	Fri, 16:45:00	Mon, 16:45:00	1 Day, 00:00:00
3	2023-12-01 16:45:00.000	2023-12-31 23:59:59.000	Fri	Sun	Fri, 16:45:00	Mon, 00:00:00	20 Days, 07:15:00
3	2023-12-02 08:00:00.000	2023-01-01 00:00:00.000	Sat	Sun	Mon, 00:00:00	Mon, 00:00:00	-240 Days, 00:00:00
3	2023-12-02 08:00:00.000	2023-12-01 08:00:00.000	Sat	Fri	Mon, 00:00:00	Fri, 08:00:00	-0 Days, 16:00:00
3	2023-12-02 08:00:00.000	2023-12-01 16:45:00.000	Sat	Fri	Mon, 00:00:00	Fri, 16:45:00	-0 Days, 07:15:00
3	2023-12-02 08:00:00.000	2023-12-02 08:00:00.000	Sat	Sat	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-02 08:00:00.000	2023-12-02 16:45:00.000	Sat	Sat	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-02 08:00:00.000	2023-12-03 08:00:00.000	Sat	Sun	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-02 08:00:00.000	2023-12-03 16:45:00.000	Sat	Sun	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-02 08:00:00.000	2023-12-04 08:00:00.000	Sat	Mon	Mon, 00:00:00	Mon, 08:00:00	0 Days, 08:00:00
3	2023-12-02 08:00:00.000	2023-12-04 16:45:00.000	Sat	Mon	Mon, 00:00:00	Mon, 16:45:00	0 Days, 16:45:00
3	2023-12-02 08:00:00.000	2023-12-31 23:59:59.000	Sat	Sun	Mon, 00:00:00	Mon, 00:00:00	20 Days, 00:00:00
3	2023-12-02 16:45:00.000	2023-01-01 00:00:00.000	Sat	Sun	Mon, 00:00:00	Mon, 00:00:00	-240 Days, 00:00:00
3	2023-12-02 16:45:00.000	2023-12-01 08:00:00.000	Sat	Fri	Mon, 00:00:00	Fri, 08:00:00	-0 Days, 16:00:00
3	2023-12-02 16:45:00.000	2023-12-01 16:45:00.000	Sat	Fri	Mon, 00:00:00	Fri, 16:45:00	-0 Days, 07:15:00
3	2023-12-02 16:45:00.000	2023-12-02 08:00:00.000	Sat	Sat	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-02 16:45:00.000	2023-12-02 16:45:00.000	Sat	Sat	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-02 16:45:00.000	2023-12-03 08:00:00.000	Sat	Sun	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-02 16:45:00.000	2023-12-03 16:45:00.000	Sat	Sun	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-02 16:45:00.000	2023-12-04 08:00:00.000	Sat	Mon	Mon, 00:00:00	Mon, 08:00:00	0 Days, 08:00:00
3	2023-12-02 16:45:00.000	2023-12-04 16:45:00.000	Sat	Mon	Mon, 00:00:00	Mon, 16:45:00	0 Days, 16:45:00
3	2023-12-02 16:45:00.000	2023-12-31 23:59:59.000	Sat	Sun	Mon, 00:00:00	Mon, 00:00:00	20 Days, 00:00:00
3	2023-12-03 08:00:00.000	2023-01-01 00:00:00.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	-240 Days, 00:00:00
3	2023-12-03 08:00:00.000	2023-12-01 08:00:00.000	Sun	Fri	Mon, 00:00:00	Fri, 08:00:00	-0 Days, 16:00:00
3	2023-12-03 08:00:00.000	2023-12-01 16:45:00.000	Sun	Fri	Mon, 00:00:00	Fri, 16:45:00	-0 Days, 07:15:00
3	2023-12-03 08:00:00.000	2023-12-02 08:00:00.000	Sun	Sat	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-03 08:00:00.000	2023-12-02 16:45:00.000	Sun	Sat	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-03 08:00:00.000	2023-12-03 08:00:00.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-03 08:00:00.000	2023-12-03 16:45:00.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-03 08:00:00.000	2023-12-04 08:00:00.000	Sun	Mon	Mon, 00:00:00	Mon, 08:00:00	0 Days, 08:00:00
3	2023-12-03 08:00:00.000	2023-12-04 16:45:00.000	Sun	Mon	Mon, 00:00:00	Mon, 16:45:00	0 Days, 16:45:00
3	2023-12-03 08:00:00.000	2023-12-31 23:59:59.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	20 Days, 00:00:00
3	2023-12-03 16:45:00.000	2023-01-01 00:00:00.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	-240 Days, 00:00:00
3	2023-12-03 16:45:00.000	2023-12-01 08:00:00.000	Sun	Fri	Mon, 00:00:00	Fri, 08:00:00	-0 Days, 16:00:00
3	2023-12-03 16:45:00.000	2023-12-01 16:45:00.000	Sun	Fri	Mon, 00:00:00	Fri, 16:45:00	-0 Days, 07:15:00
3	2023-12-03 16:45:00.000	2023-12-02 08:00:00.000	Sun	Sat	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-03 16:45:00.000	2023-12-02 16:45:00.000	Sun	Sat	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-03 16:45:00.000	2023-12-03 08:00:00.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-03 16:45:00.000	2023-12-03 16:45:00.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
3	2023-12-03 16:45:00.000	2023-12-04 08:00:00.000	Sun	Mon	Mon, 00:00:00	Mon, 08:00:00	0 Days, 08:00:00
3	2023-12-03 16:45:00.000	2023-12-04 16:45:00.000	Sun	Mon	Mon, 00:00:00	Mon, 16:45:00	0 Days, 16:45:00
3	2023-12-03 16:45:00.000	2023-12-31 23:59:59.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	20 Days, 00:00:00
3	2023-12-04 08:00:00.000	2023-01-01 00:00:00.000	Mon	Sun	Mon, 08:00:00	Mon, 00:00:00	-240 Days, 08:00:00
3	2023-12-04 08:00:00.000	2023-12-01 08:00:00.000	Mon	Fri	Mon, 08:00:00	Fri, 08:00:00	-1 Day, 00:00:00
3	2023-12-04 08:00:00.000	2023-12-01 16:45:00.000	Mon	Fri	Mon, 08:00:00	Fri, 16:45:00	-0 Days, 15:15:00
3	2023-12-04 08:00:00.000	2023-12-02 08:00:00.000	Mon	Sat	Mon, 08:00:00	Mon, 00:00:00	-0 Days, 08:00:00
3	2023-12-04 08:00:00.000	2023-12-02 16:45:00.000	Mon	Sat	Mon, 08:00:00	Mon, 00:00:00	-0 Days, 08:00:00
3	2023-12-04 08:00:00.000	2023-12-03 08:00:00.000	Mon	Sun	Mon, 08:00:00	Mon, 00:00:00	-0 Days, 08:00:00
3	2023-12-04 08:00:00.000	2023-12-03 16:45:00.000	Mon	Sun	Mon, 08:00:00	Mon, 00:00:00	-0 Days, 08:00:00
3	2023-12-04 08:00:00.000	2023-12-04 08:00:00.000	Mon	Mon	Mon, 08:00:00	Mon, 08:00:00	0 Days, 00:00:00
3	2023-12-04 08:00:00.000	2023-12-04 16:45:00.000	Mon	Mon	Mon, 08:00:00	Mon, 16:45:00	0 Days, 08:45:00
3	2023-12-04 08:00:00.000	2023-12-31 23:59:59.000	Mon	Sun	Mon, 08:00:00	Mon, 00:00:00	19 Days, 16:00:00
3	2023-12-04 16:45:00.000	2023-01-01 00:00:00.000	Mon	Sun	Mon, 16:45:00	Mon, 00:00:00	-240 Days, 16:45:00
3	2023-12-04 16:45:00.000	2023-12-01 08:00:00.000	Mon	Fri	Mon, 16:45:00	Fri, 08:00:00	-1 Day, 08:45:00
3	2023-12-04 16:45:00.000	2023-12-01 16:45:00.000	Mon	Fri	Mon, 16:45:00	Fri, 16:45:00	-1 Day, 00:00:00
3	2023-12-04 16:45:00.000	2023-12-02 08:00:00.000	Mon	Sat	Mon, 16:45:00	Mon, 00:00:00	-0 Days, 16:45:00
3	2023-12-04 16:45:00.000	2023-12-02 16:45:00.000	Mon	Sat	Mon, 16:45:00	Mon, 00:00:00	-0 Days, 16:45:00
3	2023-12-04 16:45:00.000	2023-12-03 08:00:00.000	Mon	Sun	Mon, 16:45:00	Mon, 00:00:00	-0 Days, 16:45:00
3	2023-12-04 16:45:00.000	2023-12-03 16:45:00.000	Mon	Sun	Mon, 16:45:00	Mon, 00:00:00	-0 Days, 16:45:00
3	2023-12-04 16:45:00.000	2023-12-04 08:00:00.000	Mon	Mon	Mon, 16:45:00	Mon, 08:00:00	-0 Days, 08:45:00
3	2023-12-04 16:45:00.000	2023-12-04 16:45:00.000	Mon	Mon	Mon, 16:45:00	Mon, 16:45:00	0 Days, 00:00:00
3	2023-12-04 16:45:00.000	2023-12-31 23:59:59.000	Mon	Sun	Mon, 16:45:00	Mon, 00:00:00	19 Days, 07:15:00
3	2023-12-31 23:59:59.000	2023-01-01 00:00:00.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	-260 Days, 00:00:00
3	2023-12-31 23:59:59.000	2023-12-01 08:00:00.000	Sun	Fri	Mon, 00:00:00	Fri, 08:00:00	-20 Days, 16:00:00
3	2023-12-31 23:59:59.000	2023-12-01 16:45:00.000	Sun	Fri	Mon, 00:00:00	Fri, 16:45:00	-20 Days, 07:15:00
3	2023-12-31 23:59:59.000	2023-12-02 08:00:00.000	Sun	Sat	Mon, 00:00:00	Mon, 00:00:00	-20 Days, 00:00:00
3	2023-12-31 23:59:59.000	2023-12-02 16:45:00.000	Sun	Sat	Mon, 00:00:00	Mon, 00:00:00	-20 Days, 00:00:00
3	2023-12-31 23:59:59.000	2023-12-03 08:00:00.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	-20 Days, 00:00:00
3	2023-12-31 23:59:59.000	2023-12-03 16:45:00.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	-20 Days, 00:00:00
3	2023-12-31 23:59:59.000	2023-12-04 08:00:00.000	Sun	Mon	Mon, 00:00:00	Mon, 08:00:00	-19 Days, 16:00:00
3	2023-12-31 23:59:59.000	2023-12-04 16:45:00.000	Sun	Mon	Mon, 00:00:00	Mon, 16:45:00	-19 Days, 07:15:00
3	2023-12-31 23:59:59.000	2023-12-31 23:59:59.000	Sun	Sun	Mon, 00:00:00	Mon, 00:00:00	0 Days, 00:00:00
4	2023-12-01 10:00:05.000	2023-12-01 10:00:05.000	Fri	Fri	Fri, 10:00:05	Fri, 10:00:05	0 Days, 00:00:00
4	2023-12-01 10:00:05.000	2023-12-04 11:15:10.000	Fri	Mon	Fri, 10:00:05	Mon, 11:15:10	1 Day, 01:15:05
4	2023-12-01 10:00:05.000	2023-12-06 09:00:15.000	Fri	Wed	Fri, 10:00:05	Wed, 09:00:15	2 Days, 23:00:10
4	2023-12-01 10:00:05.000	2023-12-08 15:45:20.000	Fri	Fri	Fri, 10:00:05	Fri, 15:45:20	5 Days, 05:45:15
4	2023-12-01 10:00:05.000	2023-12-11 14:30:25.000	Fri	Mon	Fri, 10:00:05	Mon, 14:30:25	6 Days, 04:30:20
4	2023-12-04 11:15:10.000	2023-12-01 10:00:05.000	Mon	Fri	Mon, 11:15:10	Fri, 10:00:05	-1 Day, 01:15:05
4	2023-12-04 11:15:10.000	2023-12-04 11:15:10.000	Mon	Mon	Mon, 11:15:10	Mon, 11:15:10	0 Days, 00:00:00
4	2023-12-04 11:15:10.000	2023-12-06 09:00:15.000	Mon	Wed	Mon, 11:15:10	Wed, 09:00:15	1 Day, 21:45:05
4	2023-12-04 11:15:10.000	2023-12-08 15:45:20.000	Mon	Fri	Mon, 11:15:10	Fri, 15:45:20	4 Days, 04:30:10
4	2023-12-04 11:15:10.000	2023-12-11 14:30:25.000	Mon	Mon	Mon, 11:15:10	Mon, 14:30:25	5 Days, 03:15:15
4	2023-12-06 09:00:15.000	2023-12-01 10:00:05.000	Wed	Fri	Wed, 09:00:15	Fri, 10:00:05	-2 Days, 23:00:10
4	2023-12-06 09:00:15.000	2023-12-04 11:15:10.000	Wed	Mon	Wed, 09:00:15	Mon, 11:15:10	-1 Day, 21:45:05
4	2023-12-06 09:00:15.000	2023-12-06 09:00:15.000	Wed	Wed	Wed, 09:00:15	Wed, 09:00:15	0 Days, 00:00:00
4	2023-12-06 09:00:15.000	2023-12-08 15:45:20.000	Wed	Fri	Wed, 09:00:15	Fri, 15:45:20	2 Days, 06:45:05
4	2023-12-06 09:00:15.000	2023-12-11 14:30:25.000	Wed	Mon	Wed, 09:00:15	Mon, 14:30:25	3 Days, 05:30:10
4	2023-12-08 15:45:20.000	2023-12-01 10:00:05.000	Fri	Fri	Fri, 15:45:20	Fri, 10:00:05	-5 Days, 05:45:15
4	2023-12-08 15:45:20.000	2023-12-04 11:15:10.000	Fri	Mon	Fri, 15:45:20	Mon, 11:15:10	-4 Days, 04:30:10
4	2023-12-08 15:45:20.000	2023-12-06 09:00:15.000	Fri	Wed	Fri, 15:45:20	Wed, 09:00:15	-2 Days, 06:45:05
4	2023-12-08 15:45:20.000	2023-12-08 15:45:20.000	Fri	Fri	Fri, 15:45:20	Fri, 15:45:20	0 Days, 00:00:00
4	2023-12-08 15:45:20.000	2023-12-11 14:30:25.000	Fri	Mon	Fri, 15:45:20	Mon, 14:30:25	0 Days, 22:45:05
4	2023-12-11 14:30:25.000	2023-12-01 10:00:05.000	Mon	Fri	Mon, 14:30:25	Fri, 10:00:05	-6 Days, 04:30:20
4	2023-12-11 14:30:25.000	2023-12-04 11:15:10.000	Mon	Mon	Mon, 14:30:25	Mon, 11:15:10	-5 Days, 03:15:15
4	2023-12-11 14:30:25.000	2023-12-06 09:00:15.000	Mon	Wed	Mon, 14:30:25	Wed, 09:00:15	-3 Days, 05:30:10
4	2023-12-11 14:30:25.000	2023-12-08 15:45:20.000	Mon	Fri	Mon, 14:30:25	Fri, 15:45:20	-0 Days, 22:45:05
4	2023-12-11 14:30:25.000	2023-12-11 14:30:25.000	Mon	Mon	Mon, 14:30:25	Mon, 14:30:25	0 Days, 00:00:00