I wanted to time parts of each episode of TNG that takes place on the Enterprise D and get the percentage of each episode. It takes me about 7 minutes to do an episode. Is anybody interested on taking on a season and adding it below?

I count time per episode spend on the Enterprise D. This includes internal and external shots. The holodeck does not count as the Enterprise D, unless part of the ship is visible (eg, the arch or grid), or part of the ship is replicated in a way (such as Geordi with Dr. Brahms). I include the credits as Enterprise D time just because it seemed unfair to count that time as being located elsewhere. I did not count brief switches to another location as this would have taken a lot of effort while only amounting to a couple of seconds.

Note that to save time, after recording the start and end times for each episode in the season, I put it all into an LLM and asked it to calculate the totals and overall percentage for the episode. I can supply the prompt for that too.

#Season 1 Ep1+2 Encounter at Farpoint: 63.6%
00:00 - 19:15 | 19:15
36:01 - 50:40 | 14:39
53:28 - 54:35 | 01:07
58:17 - 59:43 | 01:26
1:02:41 - 1:07:43 | 05:02
1:08:14 - 1:08:52 | 00:38
1:10:48 - 1:12:57 | 02:09
1:14:32 - 1:18:43 | 04:11
1:21:41 - 1:31:22 | 09:41

Ep3 The Naked Now: 94.8%
00:00 - 01:44 | 01:44
04:05 - 45:34 | 41:29

Ep4 Code of Honour: 58.2%
00:00 - 18:56 | 18:56
24:46 - 25:11 | 00:25
28:11 - 29:52 | 01:41
31:49 - 32:18 | 00:29
36:17 - 37:13 | 00:56
41:27 - 45:30 | 04:03

Ep5 The Last Outpost: 66.3%
00:00 - 26:04 | 26:04
29:14 - 29:57 | 00:43
32:31 - 33:19 | 00:48
41:10 - 41:57 | 00:47
43:43 - 45:36 | 01:53

Ep6 Where No One Has Gone Before: 100%

Ep7 Lonely Among Us: 100%

Ep8 Justice: 50.5%
00:00 - 04:18 | 04:18
09:29 - 14:30 | 05:01
22:52 - 24:10 | 01:18
29:10 - 39:21 | 10:11
43:23 - 45:34 | 02:11

Ep9 The Battle: 81.3%
00:00 - 15:26 | 15:26
18:43 - 34:15 | 15:32
34:52 - 35:26 | 00:34
36:56 - 39:44 | 02:48
40:17 - 41:57 | 01:40
44:30 - 45:31 | 01:01

Ep10 Hide and Q: 66.2%
00:00 - 06:33 | 06:33
07:10 - 08:00 | 00:50
12:34 - 16:07 | 03:33
17:00 - 19:03 | 02:03
21:40 - 23:28 | 01:48
28:18 - 30:25 | 02:07
32:16 - 45:32 | 13:16

Ep11 Haven: 91.6%
00:00 - 27:22 | 27:22
31:10 - 45:33 | 14:23

Ep12 The Big Goodbye: 43%
00:00 - 02:00 | 02:00
03:55 - 05:45 | 01:50
08:07 - 08:30 | 00:23
08:40 - 13:55 | 05:15
16:48 - 18:36 | 01:48
20:14 - 21:26 | 01:12
23:05 - 23:49 | 00:44
37:00 - 37:59 | 00:59
38:38 - 41:17 | 02:39
42:48 - 45:33 | 02:45

Ep13 Datalore: 83.1%
00:00 - 05:12 | 5:12
12:54 - 45:33 | 32:39

Ep14 Angel One: 34.3%
00:00 - 05:12 | 05:12
08:08 - 09:15 | 01:07
11:40 - 12:26 | 00:46
14:31 - 15:45 | 01:14
19:02 - 20:37 | 01:35
25:25 - 26:38 | 01:13
28:56 - 30:22 | 01:26
36:48 - 37:27 | 00:39
41:36 - 42:04 | 00:28
43:35 - 45:32 | 01:57

Ep15 11001001: 78.2%
00:00 - 15:37 | 15:37
21:35 - 25:43 | 04:08
26:50 - 27:15 | 00:25
28:48 - 30:37 | 01:49
31:09 - 33:50 | 02:41
34:41 - 43:53 | 09:12
43:49 - 45:32 | 01:43

Ep16 Too Short a Season: 77.1%
00:00 - 30:50 | 30:50
34:12 - 36:46 | 02:34
43:50 - 45:32 | 01:42

Ep17 When the Bough Breaks: 47.3%
00:00 - 09:11 | 09:11
11:17 - 12:56 | 01:39
14:00 - 15:25 | 01:25
18:09 - 19:43 | 01:34
22:25 - 23:25 | 01:00
26:07 - 27:31 | 01:24
29:40 - 30:56 | 01:16
34:00 - 34:17 | 00:17
35:15 - 36:00 | 00:45
36:40 - 37:14 | 00:34
43:07 - 45:35 | 02:28

Ep18 Home Soil: 74.5%
00:00 - 05:05 | 05:05
15:00 - 17:10 | 02:10
18:50 - 45:33 | 26:43

Ep19 Coming of Age: 81.7%
00:00 - 09:48 | 09:48
11:28 - 27:51 | 16:23
29:47 - 33:30 | 03:43
37:50 - 38:52 | 01:02
40:26 - 46:29 | 06:03

Ep20 Heart of Glory: 86.5%
00:00 - 08:10 | 08:10
14:23 - 46:04 | 31:41

Ep21 The Arsenal of Freedom: 50.3%
00:00 - 05:55 | 05:55
11:40 - 13:01 | 01:21
17:41 - 21:19 | 03:38
25:59 - 33:12 | 07:13
39:00 - 39:53 | 00:53
41:54 - 46:04 | 04:10

Ep22 Symbiosis: 100%

Ep23 Skin of Evil: 29.8%
00:00 - 07:22 | 07:22
10:12 - 10:38 | 00:26
12:20 - 14:44 | 02:24
16:58 - 18:58 | 02:00
26:32 - 27:21 | 00:49
35:10 - 35:20 | 00:10
38:08 - 38:40 | 00:32

Ep24 We'll Always Have Paris: 81.7%
00:00 - 08:49 | 08:49
11:51 - 35:32 | 23:41
39:23 - 42:10 | 02:47
43:43 - 46:04 | 02:21

Ep25 Conspiracy: 68.5%
00:00 - 08:56 | 08:56
14:15 - 28:27 | 14:12
29:17 - 30:50 | 01:33
31:59 - 34:38 | 02:39
35:39 - 37:10 | 01:31
43:21 - 46:04 | 02:43

Ep26 The Neutral Zone: 93.9%
00:00 - 01:10 | 01:10
03:21 - 05:03 | 01:42
05:40 - 46:04 | 40:42

Episode reference: https://en.wikipedia.org/wiki/List_of_Star_Trek:_The_Next_Generation_episodes#Season_1_(1987%E2%80%931988)