Output:ShiftDate Shift StartDate Duration DetailCode
18-03-2021 0:00 1 18-03-2021 6:00 13.37 0.009284722
18-03-2021 0:00 1 18-03-2021 6:48 1.07 0.000743056
18-03-2021 0:00 1 18-03-2021 6:56 2.68 0.001861111
18-03-2021 0:00 1 18-03-2021 7:41 9.65 0.006701389
18-03-2021 0:00 1 18-03-2021 8:25 6.8 0.004722222
18-03-2021 0:00 1 18-03-2021 9:10 6.75 0.0046875
18-03-2021 0:00 1 18-03-2021 9:22 2.03 0.001409722
18-03-2021 0:00 1 18-03-2021 9:27 2.95 0.002048611
18-03-2021 0:00 1 18-03-2021 9:33 1.55 0.001076389
18-03-2021 0:00 1 18-03-2021 10:02 30 0.020833333
18-03-2021 0:00 1 18-03-2021 10:32 7.63 0.005298611
18-03-2021 0:00 1 18-03-2021 12:25 10.37 0.007201389
18-03-2021 0:00 1 18-03-2021 13:02 3.8 0.002638889
18-03-2021 0:00 1 18-03-2021 13:25 2.53 0.001756944
18-03-2021 0:00 1 18-03-2021 13:31 9.33 0.006479167
18-03-2021 0:00 1 18-03-2021 13:43 17 0.011805556
18-03-2021 0:00 1 18-03-2021 14:00 7.58 0.005263889
18-03-2021 0:00 1 18-03-2021 14:11 1.53 0.0010625
18-03-2021 0:00 1 18-03-2021 14:39 14.85 0.0103125
18-03-2021 0:00 1 18-03-2021 15:58 2.35 0.001631944
18-03-2021 0:00 1 18-03-2021 16:31 1.03 0.000715278
18-03-2021 0:00 1 18-03-2021 17:02 13.45 0.009340278
18-03-2021 0:00 1 18-03-2021 17:54 1.2 0.000833333
18-03-2021 0:00 1 18-03-2021 18:09 30 0.020833333
18-03-2021 0:00 1 18-03-2021 18:39 15.2 0.010555556
18-03-2021 0:00 1 18-03-2021 19:51 2.15 0.001493056
18-03-2021 0:00 1 18-03-2021 20:53 16.4 0.011388889
18-03-2021 0:00 1 18-03-2021 21:13 1.52 0.001055556
18-03-2021 0:00 1 18-03-2021 21:18 2.28 0.001583333
18-03-2021 0:00 1 18-03-2021 21:27 16.38 0.011375
18-03-2021 0:00 1 18-03-2021 21:46 14 0.009722222
18-03-2021 0:00 1 18-03-2021 22:00 3.55 0.002465278
18-03-2021 0:00 1 18-03-2021 23:59 9 0.00625
18-03-2021 0:00 1 19-03-2021 0:08 11 0.007638889
18-03-2021 0:00 1 19-03-2021 0:19 13.2 0.009166667
18-03-2021 0:00 1 19-03-2021 2:08 29.9 0.020763889
18-03-2021 0:00 1 19-03-2021 4:47 1.92 0.001333333
18-03-2021 0:00 1 19-03-2021 5:49 11 0.007638889
Larz60+ write Mar-20-2021, 11:15 AM:
Please post all code, output and errors (it it's entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.
Note: Input data looks better when surrounded by output tags.
Unfortunately there are no input tags available.
Added for you this time. Please use bbcode tags on future posts
Please post all code, output and errors (it it's entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.
Note: Input data looks better when surrounded by output tags.
Unfortunately there are no input tags available.
Added for you this time. Please use bbcode tags on future posts