SQL Server 2022

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

CREATE TABLE Process (Name VARCHAR(100), Start DATETIME, Finish DATETIME)
CREATE TABLE Shift (Name VARCHAR(100), Start TIME, Finish TIME)

INSERT Process
VALUES
    ('Process 1', '2023-11-18 04:30', '2023-11-18 04:31') -- 1 minute
    ,('Process 2', '2023-11-19 00:30', '2023-11-19 00:31') -- 1 minute
    ,('Process 3', '2023-11-22 23:45', '2023-11-23 00:15') -- 30 minutes, spans midnight
    ,('Process 4', '2023-11-24 23:45', '2023-11-27 00:15') -- 24.5 hours, spans 4 days
INSERT Shift
VALUES
    ('Shift 1', '16:00', '01:00')
    ,('Shift 2', '23:00', '07:00')
    ,('Shift 3', '01:00', '02:00') -- Short shift
    ,('Shift 4', '07:00', '16:00')
    ,('Shift 5', '12:00', '21:00')
9 rows affected

SELECT
    P.Name AS PName
    ,CONVERT(SMALLDATETIME, P.Start) AS PStart
    ,CONVERT(SMALLDATETIME, P.Finish) AS PFinish
    ,SUM(DATEDIFF(minute, GREATEST(P.Start, SS.Start), LEAST(P.Finish, SS.Finish))) AS Minutes
    ,S.Name AS SName
    ,CONVERT(CHAR(5), S.Start, 8) AS SStart
    ,CONVERT(CHAR(5), S.Finish, 8) AS SFinish
FROM (
    -- Process data plus some calculated fields
    SELECT
        P.*,
        CONVERT(DATE, P.Start) AS StartDate,
        DATEDIFF(day, P.Start, P.Finish) AS Days
    FROM Process P
) P
CROSS JOIN (
    -- Shift data plus a check for midnight crossover
    SELECT
        S.*,
        CASE WHEN S.Start > S.Finish THEN 1 ELSE 0 END AS CrossOver
    FROM Shift S
) S
CROSS APPLY (
    -- Replicate shifts across all dates covered by each process
    SELECT
        CONVERT(DATETIME, DATEADD(day, G.value, P.StartDate)) + CONVERT(DATETIME, S.Start) AS Start,
        CONVERT(DATETIME, DATEADD(day, G.value + S.Crossover, P.StartDate)) + CONVERT(DATETIME, S.Finish) AS Finish  
    FROM GENERATE_SERIES(-S.Crossover, P.Days) G
) SS
WHERE (P.Start < SS.Finish AND SS.Start < P.Finish) -- overlap test
GROUP BY
    P.Name, P.Start, P.Finish
    ,S.Name, S.Start, S.Finish
ORDER BY P.Name, S.Name


PName
PStart
PFinish
Minutes
SName
SStart
SFinish


Process 1
2023-11-18 04:30
2023-11-18 04:31
1
Shift 2
23:00
07:00

Process 2
2023-11-19 00:30
2023-11-19 00:31
1
Shift 1
16:00
01:00

Process 2
2023-11-19 00:30
2023-11-19 00:31
1
Shift 2
23:00
07:00

Process 3
2023-11-22 23:45
2023-11-23 00:15
30
Shift 1
16:00
01:00

Process 3
2023-11-22 23:45
2023-11-23 00:15
30
Shift 2
23:00
07:00

Process 4
2023-11-24 23:45
2023-11-27 00:15
1110
Shift 1
16:00
01:00

Process 4
2023-11-24 23:45
2023-11-27 00:15
990
Shift 2
23:00
07:00

Process 4
2023-11-24 23:45
2023-11-27 00:15
120
Shift 3
01:00
02:00

Process 4
2023-11-24 23:45
2023-11-27 00:15
1080
Shift 4
07:00
16:00

Process 4
2023-11-24 23:45
2023-11-27 00:15
1080
Shift 5
12:00
21:00


-- Raw results
SELECT
    DATEDIFF(minute, GREATEST(P.Start, SS.Start), LEAST(P.Finish, SS.Finish)) AS Minutes,
    *
FROM (
    -- Process data plus some calculated fields
    SELECT
        P.*,
        CONVERT(DATE, P.Start) AS StartDate,
        DATEDIFF(day, P.Start, P.Finish) AS Days
    FROM Process P
) P
CROSS JOIN (
    -- Shift data plus a check for midnight crossover
    SELECT
        S.*,
        CASE WHEN S.Start > S.Finish THEN 1 ELSE 0 END AS CrossOver
    FROM Shift S
) S
CROSS APPLY (
    -- Replicate shifts across all dates covered by each process
    SELECT
        CONVERT(DATETIME, DATEADD(day, G.value, P.StartDate)) + CONVERT(DATETIME, S.Start) AS Start,
        CONVERT(DATETIME, DATEADD(day, G.value + S.Crossover, P.StartDate)) + CONVERT(DATETIME, S.Finish) AS Finish  
    FROM GENERATE_SERIES(-S.Crossover, P.Days) G
) SS
WHERE (P.Start < SS.Finish AND SS.Start < P.Finish) -- overlap test
ORDER BY P.Name, S.Name, SS.Start


Minutes
Name
Start
Finish
StartDate
Days
Name
Start
Finish
CrossOver
Start
Finish


1
Process 1
2023-11-18 04:30:00.000
2023-11-18 04:31:00.000
2023-11-18
0
Shift 2
23:00:00.0000000
07:00:00.0000000
1
2023-11-17 23:00:00.000
2023-11-18 07:00:00.000

1
Process 2
2023-11-19 00:30:00.000
2023-11-19 00:31:00.000
2023-11-19
0
Shift 1
16:00:00.0000000
01:00:00.0000000
1
2023-11-18 16:00:00.000
2023-11-19 01:00:00.000

1
Process 2
2023-11-19 00:30:00.000
2023-11-19 00:31:00.000
2023-11-19
0
Shift 2
23:00:00.0000000
07:00:00.0000000
1
2023-11-18 23:00:00.000
2023-11-19 07:00:00.000

30
Process 3
2023-11-22 23:45:00.000
2023-11-23 00:15:00.000
2023-11-22
1
Shift 1
16:00:00.0000000
01:00:00.0000000
1
2023-11-22 16:00:00.000
2023-11-23 01:00:00.000

30
Process 3
2023-11-22 23:45:00.000
2023-11-23 00:15:00.000
2023-11-22
1
Shift 2
23:00:00.0000000
07:00:00.0000000
1
2023-11-22 23:00:00.000
2023-11-23 07:00:00.000

75
Process 4
2023-11-24 23:45:00.000
2023-11-27 00:15:00.000
2023-11-24
3
Shift 1
16:00:00.0000000
01:00:00.0000000
1
2023-11-24 16:00:00.000
2023-11-25 01:00:00.000

540
Process 4
2023-11-24 23:45:00.000
2023-11-27 00:15:00.000
2023-11-24
3
Shift 1
16:00:00.0000000
01:00:00.0000000
1
2023-11-25 16:00:00.000
2023-11-26 01:00:00.000

495
Process 4
2023-11-24 23:45:00.000
2023-11-27 00:15:00.000
2023-11-24
3
Shift 1
16:00:00.0000000
01:00:00.0000000
1
2023-11-26 16:00:00.000
2023-11-27 01:00:00.000

435
Process 4
2023-11-24 23:45:00.000
2023-11-27 00:15:00.000
2023-11-24
3
Shift 2
23:00:00.0000000
07:00:00.0000000
1
2023-11-24 23:00:00.000
2023-11-25 07:00:00.000

480
Process 4
2023-11-24 23:45:00.000
2023-11-27 00:15:00.000
2023-11-24
3
Shift 2
23:00:00.0000000
07:00:00.0000000
1
2023-11-25 23:00:00.000
2023-11-26 07:00:00.000

75
Process 4
2023-11-24 23:45:00.000
2023-11-27 00:15:00.000
2023-11-24
3
Shift 2
23:00:00.0000000
07:00:00.0000000
1
2023-11-26 23:00:00.000
2023-11-27 07:00:00.000

60
Process 4
2023-11-24 23:45:00.000
2023-11-27 00:15:00.000
2023-11-24
3
Shift 3
01:00:00.0000000
02:00:00.0000000
0
2023-11-25 01:00:00.000
2023-11-25 02:00:00.000

60
Process 4
2023-11-24 23:45:00.000
2023-11-27 00:15:00.000
2023-11-24
3
Shift 3
01:00:00.0000000
02:00:00.0000000
0
2023-11-26 01:00:00.000
2023-11-26 02:00:00.000

540
Process 4
2023-11-24 23:45:00.000
2023-11-27 00:15:00.000
2023-11-24
3
Shift 4
07:00:00.0000000
16:00:00.0000000
0
2023-11-25 07:00:00.000
2023-11-25 16:00:00.000

540
Process 4
2023-11-24 23:45:00.000
2023-11-27 00:15:00.000
2023-11-24
3
Shift 4
07:00:00.0000000
16:00:00.0000000
0
2023-11-26 07:00:00.000
2023-11-26 16:00:00.000

540
Process 4
2023-11-24 23:45:00.000
2023-11-27 00:15:00.000
2023-11-24
3
Shift 5
12:00:00.0000000
21:00:00.0000000
0
2023-11-25 12:00:00.000
2023-11-25 21:00:00.000

540
Process 4
2023-11-24 23:45:00.000
2023-11-27 00:15:00.000
2023-11-24
3
Shift 5
12:00:00.0000000
21:00:00.0000000
0
2023-11-26 12:00:00.000
2023-11-26 21:00:00.000


-- Another approach that splits processes up into individual dates
-- Much more complicated, but results are the same
DECLARE @NullDate DATE = NULL
DECLARE @T0000 DATETIME = 0
DECLARE @T2400 DATETIME = DATEADD(hour, 24, @T0000)

;WITH CTE_Process_Split AS (
    -- For processes than span days, split up into multiple segments - one per day.
    SELECT P.*, PS.*
    FROM Process P
    CROSS APPLY (
        SELECT
            CONVERT(DATE, P.Start) AS StartDate,
            CONVERT(DATE, P.Finish) AS FinishDate,
            CONVERT(TIME, P.Start) AS StartTime,
            CONVERT(TIME, P.Finish) AS FinishTime,
            DATEDIFF(Day, P.Start, P.Finish) AS DayDiff
    ) PD
    CROSS APPLY (
        -- Establish types and column names, returning zero rows
        SELECT @NullDate AS SplitDate, @T0000 AS SplitStart, @T0000 AS SplitFinish WHERE 1 = 0
        -- For a process that starts and ends on the same day, leave as is
        UNION ALL SELECT PD.StartDate, PD.StartTime, PD.FinishTime WHERE PD.DayDiff = 0
        -- For a process with one midnight crossover, split into two segments
        UNION ALL SELECT PD.StartDate, PD.StartTime, @T2400 WHERE PD.DayDiff >= 1
        UNION ALL SELECT PD.FinishDate, @T0000, PD.FinishTime WHERE PD.DayDiff >= 1 AND PD.FinishTime >= '00:00'
        -- If a process spans 3 or more days, Generate one or more 24 hour splits 
        UNION ALL SELECT DATEADD(day, G.value, PD.StartDate), @T0000, @T2400
            FROM GENERATE_SERIES(1, PD.DayDiff - 1) G
            WHERE PD.DayDiff >= 2
    ) PS
),
CTE_Shift_Split AS (
    -- For shifts crossing midnight, split into separate morning and evening segments.
    SELECT S.*, SS.*
    FROM Shift S
    CROSS APPLY (
        SELECT CASE WHEN S.Start > S.Finish THEN 1 ELSE 0 END AS CrossOver
    ) SC
    CROSS APPLY (
        -- Establish types and column names, returning zero rows
        SELECT @T0000 AS SplitStart, @T0000 AS SplitFinish WHERE 1 = 0
        -- Shift that starts and ends on the same day - leave as is (omit 0 length)
        UNION ALL SELECT S.Start, S.Finish WHERE CrossOver = 0 AND S.Start < S.Finish
        -- For processes with one midnight crossover, split into two segments
        UNION ALL SELECT S.Start, @T2400 WHERE CrossOver = 1
        UNION ALL SELECT @T0000, S.Finish WHERE CrossOver = 1 AND S.Finish >= '00:00'
    ) SS
)
SELECT
    PS.Name AS PName
    ,CONVERT(SMALLDATETIME, PS.Start) AS PStart
    ,CONVERT(SMALLDATETIME, PS.Finish) AS PFinish
    ,SUM(DATEDIFF(minute, GREATEST(PS.SplitStart, SS.SplitStart), LEAST(PS.SplitFinish, SS.SplitFinish))) AS Minutes
    ,SS.Name AS SName
    ,CONVERT(CHAR(5), SS.Start, 8) AS SStart
    ,CONVERT(CHAR(5), SS.Finish, 8) AS SFinish
FROM CTE_Process_Split PS
CROSS JOIN CTE_Shift_Split SS
WHERE (PS.SplitStart < SS.SplitFinish AND SS.SplitStart < PS.SplitFinish) -- Overlap test
GROUP BY
    PS.Name, PS.Start, PS.Finish
    ,SS.Name, SS.Start, SS.Finish
ORDER BY PS.Name, SS.Name


PName
PStart
PFinish
Minutes
SName
SStart
SFinish


Process 1
2023-11-18 04:30
2023-11-18 04:31
1
Shift 2
23:00
07:00

Process 2
2023-11-19 00:30
2023-11-19 00:31
1
Shift 1
16:00
01:00

Process 2
2023-11-19 00:30
2023-11-19 00:31
1
Shift 2
23:00
07:00

Process 3
2023-11-22 23:45
2023-11-23 00:15
30
Shift 1
16:00
01:00

Process 3
2023-11-22 23:45
2023-11-23 00:15
30
Shift 2
23:00
07:00

Process 4
2023-11-24 23:45
2023-11-27 00:15
1110
Shift 1
16:00
01:00

Process 4
2023-11-24 23:45
2023-11-27 00:15
990
Shift 2
23:00
07:00

Process 4
2023-11-24 23:45
2023-11-27 00:15
120
Shift 3
01:00
02:00

Process 4
2023-11-24 23:45
2023-11-27 00:15
1080
Shift 4
07:00
16:00

Process 4
2023-11-24 23:45
2023-11-27 00:15
1080
Shift 5
12:00
21:00


-- "Another more complicated approach" - Raw results
DECLARE @NullDate DATE = NULL
DECLARE @T0000 DATETIME = 0
DECLARE @T2400 DATETIME = DATEADD(hour, 24, @T0000)

;WITH CTE_Process_Split AS (
    SELECT P.*, PS.*
    FROM Process P
    CROSS APPLY (
        SELECT
            CONVERT(DATE, P.Start) AS StartDate,
            CONVERT(DATE, P.Finish) AS FinishDate,
            CONVERT(TIME, P.Start) AS StartTime,
            CONVERT(TIME, P.Finish) AS FinishTime,
            DATEDIFF(Day, P.Start, P.Finish) AS DayDiff
    ) PD
    CROSS APPLY (
        -- Establish types and column names, returning zero rows
        SELECT @NullDate AS SplitDate, @T0000 AS SplitStart, @T0000 AS SplitFinish WHERE 1 = 0
        -- For a process that starts and ends on the same day, leave as is
        UNION ALL SELECT PD.StartDate, PD.StartTime, PD.FinishTime WHERE PD.DayDiff = 0
        -- For a process with one midnight crossover, split into two segments
        UNION ALL SELECT PD.StartDate, PD.StartTime, @T2400 WHERE PD.DayDiff >= 1
        UNION ALL SELECT PD.FinishDate, @T0000, PD.FinishTime WHERE PD.DayDiff >= 1 AND PD.FinishTime >= '00:00'
        -- If a process spans 3 or more days, Generate one or more 24 hour splits 
        UNION ALL SELECT DATEADD(day, G.value, PD.StartDate), @T0000, @T2400
            FROM GENERATE_SERIES(1, PD.DayDiff - 1) G
            WHERE PD.DayDiff >= 2
    ) PS
),
CTE_Shift_Split AS (
    SELECT S.*, SS.*
    FROM Shift S
    CROSS APPLY (
        SELECT CASE WHEN S.Start > S.Finish THEN 1 ELSE 0 END AS CrossOver
    ) SC
    CROSS APPLY (
        -- Establish types and column names, returning zero rows
        SELECT @T0000 AS SplitStart, @T0000 AS SplitFinish WHERE 1 = 0
        -- Shift that starts and ends on the same day - leave as is (omit 0 length)
        UNION ALL SELECT S.Start, S.Finish WHERE CrossOver = 0 AND S.Start < S.Finish
        -- For processes with one midnight crossover, split into two segments
        UNION ALL SELECT S.Start, @T2400 WHERE CrossOver = 1
        UNION ALL SELECT @T0000, S.Finish WHERE CrossOver = 1 AND S.Finish >= '00:00'
    ) SS
)
SELECT
    PS.Name AS PName
    --,CONVERT(SMALLDATETIME, PS.Start) AS PStart
    --,CONVERT(SMALLDATETIME, PS.Finish) AS PFinish
    ,PS.SplitDate AS PSDate
    ,CONVERT(CHAR(5), PS.SplitStart, 8) AS PSStart
    ,CONVERT(CHAR(5), PS.SplitFinish, 8) AS PSFinish
    ,DATEDIFF(minute, GREATEST(PS.SplitStart, SS.SplitStart), LEAST(PS.SplitFinish, SS.SplitFinish)) AS Minutes
    ,CONVERT(CHAR(5), GREATEST(PS.SplitStart, SS.SplitStart), 8) AS MatchStart
    ,CONVERT(CHAR(5), LEAST(PS.SplitFinish, SS.SplitFinish), 8) AS MatchFinish
    ,SS.Name AS SName
    ,CONVERT(CHAR(5), SS.SplitStart, 8) AS SSStart
    ,CONVERT(CHAR(5), SS.SplitFinish, 8) AS SSFinish
    --,CONVERT(CHAR(5), SS.Start, 8) AS SStart
    --,CONVERT(CHAR(5), SS.Finish, 8) AS SFinish
FROM CTE_Process_Split PS
CROSS JOIN CTE_Shift_Split SS
WHERE (PS.SplitStart < SS.SplitFinish AND SS.SplitStart < PS.SplitFinish) -- Overlap test
ORDER BY PS.Name, PS.SplitDate, SS.Name, SS.SplitStart


PName
PSDate
PSStart
PSFinish
Minutes
MatchStart
MatchFinish
SName
SSStart
SSFinish


Process 1
2023-11-18
04:30
04:31
1
04:30
04:31
Shift 2
00:00
07:00

Process 2
2023-11-19
00:30
00:31
1
00:30
00:31
Shift 1
00:00
01:00

Process 2
2023-11-19
00:30
00:31
1
00:30
00:31
Shift 2
00:00
07:00

Process 3
2023-11-22
23:45
00:00
15
23:45
00:00
Shift 1
16:00
00:00

Process 3
2023-11-22
23:45
00:00
15
23:45
00:00
Shift 2
23:00
00:00

Process 3
2023-11-23
00:00
00:15
15
00:00
00:15
Shift 1
00:00
01:00

Process 3
2023-11-23
00:00
00:15
15
00:00
00:15
Shift 2
00:00
07:00

Process 4
2023-11-24
23:45
00:00
15
23:45
00:00
Shift 1
16:00
00:00

Process 4
2023-11-24
23:45
00:00
15
23:45
00:00
Shift 2
23:00
00:00

Process 4
2023-11-25
00:00
00:00
60
00:00
01:00
Shift 1
00:00
01:00

Process 4
2023-11-25
00:00
00:00
480
16:00
00:00
Shift 1
16:00
00:00

Process 4
2023-11-25
00:00
00:00
420
00:00
07:00
Shift 2
00:00
07:00

Process 4
2023-11-25
00:00
00:00
60
23:00
00:00
Shift 2
23:00
00:00

Process 4
2023-11-25
00:00
00:00
60
01:00
02:00
Shift 3
01:00
02:00

Process 4
2023-11-25
00:00
00:00
540
07:00
16:00
Shift 4
07:00
16:00

Process 4
2023-11-25
00:00
00:00
540
12:00
21:00
Shift 5
12:00
21:00

Process 4
2023-11-26
00:00
00:00
60
00:00
01:00
Shift 1
00:00
01:00

Process 4
2023-11-26
00:00
00:00
480
16:00
00:00
Shift 1
16:00
00:00

Process 4
2023-11-26
00:00
00:00
420
00:00
07:00
Shift 2
00:00
07:00

Process 4
2023-11-26
00:00
00:00
60
23:00
00:00
Shift 2
23:00
00:00

Process 4
2023-11-26
00:00
00:00
60
01:00
02:00
Shift 3
01:00
02:00

Process 4
2023-11-26
00:00
00:00
540
07:00
16:00
Shift 4
07:00
16:00

Process 4
2023-11-26
00:00
00:00
540
12:00
21:00
Shift 5
12:00
21:00

Process 4
2023-11-27
00:00
00:15
15
00:00
00:15
Shift 1
00:00
01:00

Process 4
2023-11-27
00:00
00:15
15
00:00
00:15
Shift 2
00:00
07:00

PName	PStart	PFinish	Minutes	SName	SStart	SFinish
Process 1	2023-11-18 04:30	2023-11-18 04:31	1	Shift 2	23:00	07:00
Process 2	2023-11-19 00:30	2023-11-19 00:31	1	Shift 1	16:00	01:00
Process 2	2023-11-19 00:30	2023-11-19 00:31	1	Shift 2	23:00	07:00
Process 3	2023-11-22 23:45	2023-11-23 00:15	30	Shift 1	16:00	01:00
Process 3	2023-11-22 23:45	2023-11-23 00:15	30	Shift 2	23:00	07:00
Process 4	2023-11-24 23:45	2023-11-27 00:15	1110	Shift 1	16:00	01:00
Process 4	2023-11-24 23:45	2023-11-27 00:15	990	Shift 2	23:00	07:00
Process 4	2023-11-24 23:45	2023-11-27 00:15	120	Shift 3	01:00	02:00
Process 4	2023-11-24 23:45	2023-11-27 00:15	1080	Shift 4	07:00	16:00
Process 4	2023-11-24 23:45	2023-11-27 00:15	1080	Shift 5	12:00	21:00

Minutes	Name	Start	Finish	StartDate	Days	Name	Start	Finish	CrossOver	Start	Finish
1	Process 1	2023-11-18 04:30:00.000	2023-11-18 04:31:00.000	2023-11-18	0	Shift 2	23:00:00.0000000	07:00:00.0000000	1	2023-11-17 23:00:00.000	2023-11-18 07:00:00.000
1	Process 2	2023-11-19 00:30:00.000	2023-11-19 00:31:00.000	2023-11-19	0	Shift 1	16:00:00.0000000	01:00:00.0000000	1	2023-11-18 16:00:00.000	2023-11-19 01:00:00.000
1	Process 2	2023-11-19 00:30:00.000	2023-11-19 00:31:00.000	2023-11-19	0	Shift 2	23:00:00.0000000	07:00:00.0000000	1	2023-11-18 23:00:00.000	2023-11-19 07:00:00.000
30	Process 3	2023-11-22 23:45:00.000	2023-11-23 00:15:00.000	2023-11-22	1	Shift 1	16:00:00.0000000	01:00:00.0000000	1	2023-11-22 16:00:00.000	2023-11-23 01:00:00.000
30	Process 3	2023-11-22 23:45:00.000	2023-11-23 00:15:00.000	2023-11-22	1	Shift 2	23:00:00.0000000	07:00:00.0000000	1	2023-11-22 23:00:00.000	2023-11-23 07:00:00.000
75	Process 4	2023-11-24 23:45:00.000	2023-11-27 00:15:00.000	2023-11-24	3	Shift 1	16:00:00.0000000	01:00:00.0000000	1	2023-11-24 16:00:00.000	2023-11-25 01:00:00.000
540	Process 4	2023-11-24 23:45:00.000	2023-11-27 00:15:00.000	2023-11-24	3	Shift 1	16:00:00.0000000	01:00:00.0000000	1	2023-11-25 16:00:00.000	2023-11-26 01:00:00.000
495	Process 4	2023-11-24 23:45:00.000	2023-11-27 00:15:00.000	2023-11-24	3	Shift 1	16:00:00.0000000	01:00:00.0000000	1	2023-11-26 16:00:00.000	2023-11-27 01:00:00.000
435	Process 4	2023-11-24 23:45:00.000	2023-11-27 00:15:00.000	2023-11-24	3	Shift 2	23:00:00.0000000	07:00:00.0000000	1	2023-11-24 23:00:00.000	2023-11-25 07:00:00.000
480	Process 4	2023-11-24 23:45:00.000	2023-11-27 00:15:00.000	2023-11-24	3	Shift 2	23:00:00.0000000	07:00:00.0000000	1	2023-11-25 23:00:00.000	2023-11-26 07:00:00.000
75	Process 4	2023-11-24 23:45:00.000	2023-11-27 00:15:00.000	2023-11-24	3	Shift 2	23:00:00.0000000	07:00:00.0000000	1	2023-11-26 23:00:00.000	2023-11-27 07:00:00.000
60	Process 4	2023-11-24 23:45:00.000	2023-11-27 00:15:00.000	2023-11-24	3	Shift 3	01:00:00.0000000	02:00:00.0000000	0	2023-11-25 01:00:00.000	2023-11-25 02:00:00.000
60	Process 4	2023-11-24 23:45:00.000	2023-11-27 00:15:00.000	2023-11-24	3	Shift 3	01:00:00.0000000	02:00:00.0000000	0	2023-11-26 01:00:00.000	2023-11-26 02:00:00.000
540	Process 4	2023-11-24 23:45:00.000	2023-11-27 00:15:00.000	2023-11-24	3	Shift 4	07:00:00.0000000	16:00:00.0000000	0	2023-11-25 07:00:00.000	2023-11-25 16:00:00.000
540	Process 4	2023-11-24 23:45:00.000	2023-11-27 00:15:00.000	2023-11-24	3	Shift 4	07:00:00.0000000	16:00:00.0000000	0	2023-11-26 07:00:00.000	2023-11-26 16:00:00.000
540	Process 4	2023-11-24 23:45:00.000	2023-11-27 00:15:00.000	2023-11-24	3	Shift 5	12:00:00.0000000	21:00:00.0000000	0	2023-11-25 12:00:00.000	2023-11-25 21:00:00.000
540	Process 4	2023-11-24 23:45:00.000	2023-11-27 00:15:00.000	2023-11-24	3	Shift 5	12:00:00.0000000	21:00:00.0000000	0	2023-11-26 12:00:00.000	2023-11-26 21:00:00.000

PName	PSDate	PSStart	PSFinish	Minutes	MatchStart	MatchFinish	SName	SSStart	SSFinish
Process 1	2023-11-18	04:30	04:31	1	04:30	04:31	Shift 2	00:00	07:00
Process 2	2023-11-19	00:30	00:31	1	00:30	00:31	Shift 1	00:00	01:00
Process 2	2023-11-19	00:30	00:31	1	00:30	00:31	Shift 2	00:00	07:00
Process 3	2023-11-22	23:45	00:00	15	23:45	00:00	Shift 1	16:00	00:00
Process 3	2023-11-22	23:45	00:00	15	23:45	00:00	Shift 2	23:00	00:00
Process 3	2023-11-23	00:00	00:15	15	00:00	00:15	Shift 1	00:00	01:00
Process 3	2023-11-23	00:00	00:15	15	00:00	00:15	Shift 2	00:00	07:00
Process 4	2023-11-24	23:45	00:00	15	23:45	00:00	Shift 1	16:00	00:00
Process 4	2023-11-24	23:45	00:00	15	23:45	00:00	Shift 2	23:00	00:00
Process 4	2023-11-25	00:00	00:00	60	00:00	01:00	Shift 1	00:00	01:00
Process 4	2023-11-25	00:00	00:00	480	16:00	00:00	Shift 1	16:00	00:00
Process 4	2023-11-25	00:00	00:00	420	00:00	07:00	Shift 2	00:00	07:00
Process 4	2023-11-25	00:00	00:00	60	23:00	00:00	Shift 2	23:00	00:00
Process 4	2023-11-25	00:00	00:00	60	01:00	02:00	Shift 3	01:00	02:00
Process 4	2023-11-25	00:00	00:00	540	07:00	16:00	Shift 4	07:00	16:00
Process 4	2023-11-25	00:00	00:00	540	12:00	21:00	Shift 5	12:00	21:00
Process 4	2023-11-26	00:00	00:00	60	00:00	01:00	Shift 1	00:00	01:00
Process 4	2023-11-26	00:00	00:00	480	16:00	00:00	Shift 1	16:00	00:00
Process 4	2023-11-26	00:00	00:00	420	00:00	07:00	Shift 2	00:00	07:00
Process 4	2023-11-26	00:00	00:00	60	23:00	00:00	Shift 2	23:00	00:00
Process 4	2023-11-26	00:00	00:00	60	01:00	02:00	Shift 3	01:00	02:00
Process 4	2023-11-26	00:00	00:00	540	07:00	16:00	Shift 4	07:00	16:00
Process 4	2023-11-26	00:00	00:00	540	12:00	21:00	Shift 5	12:00	21:00
Process 4	2023-11-27	00:00	00:15	15	00:00	00:15	Shift 1	00:00	01:00
Process 4	2023-11-27	00:00	00:15	15	00:00	00:15	Shift 2	00:00	07:00