Temperatur an einem Ort um 17:Uhr ein ganzes Jahr

Gast #6933905
Hallo Excel-Freaks,
da ich Excel überhaupt nicht kann eine Frage in die Runde.
Habe Wetterdaten (Temeperatur) für ein Jahr in Koblenz als Datei 
bekommen.
Ich will aber aus dieser Datei nur eine Uhrzeit (17.00 Uhr) pro Tag über 
das ganze Jahr haben, also 365 Temeperatur-Werte jeweils immer unm 17:00 
Uhr
Kann mir da einer was basteln. Händisch dauert das ewig.

Beispiel:
OBS_DEU_PT1H_T2M,"2656","1982-01-01T17:00:00","8.1","0","7",
Das wäre also am 1.1.82 um 17 Uhr genau 8,1 Grad Celsius
Angehängte Dateien:
#6933913
Hol dir vscode, wähle den Text T17:00:00 aus und drück Strg+Shift+L, 
Pos1, Shift+Ende, Strg+C und füge den Inhalt irgendwo ein, wie hier:
1
"OBS_DEU_PT1H_T2M","2656","1982-01-01T17:00:00","8.1","0","7",
2
"OBS_DEU_PT1H_T2M","2656","1982-01-02T17:00:00","7.1","0","7",
3
"OBS_DEU_PT1H_T2M","2656","1982-01-03T17:00:00","10.4","0","7",
4
"OBS_DEU_PT1H_T2M","2656","1982-01-04T17:00:00","11.7","0","7",
5
"OBS_DEU_PT1H_T2M","2656","1982-01-05T17:00:00","9.3","0","7",
6
"OBS_DEU_PT1H_T2M","2656","1982-01-06T17:00:00","-2.9","0","7",
7
"OBS_DEU_PT1H_T2M","2656","1982-01-07T17:00:00","-3.6","0","7",
8
"OBS_DEU_PT1H_T2M","2656","1982-01-08T17:00:00","-5.7","0","7",
9
"OBS_DEU_PT1H_T2M","2656","1982-01-09T17:00:00","-5.8","0","7",
10
"OBS_DEU_PT1H_T2M","2656","1982-01-10T17:00:00","-7.3","0","7",
11
"OBS_DEU_PT1H_T2M","2656","1982-01-11T17:00:00","-5","0","7",
12
"OBS_DEU_PT1H_T2M","2656","1982-01-12T17:00:00","-6.4","0","7",
13
"OBS_DEU_PT1H_T2M","2656","1982-01-13T17:00:00","-9.8","0","7",
14
"OBS_DEU_PT1H_T2M","2656","1982-01-14T17:00:00","-9.1","0","7",
15
"OBS_DEU_PT1H_T2M","2656","1982-01-15T17:00:00","-3","0","7",
16
"OBS_DEU_PT1H_T2M","2656","1982-01-16T17:00:00","0.6","0","7",
17
"OBS_DEU_PT1H_T2M","2656","1982-01-17T17:00:00","-0.7","0","7",
18
"OBS_DEU_PT1H_T2M","2656","1982-01-18T17:00:00","-1.2","0","7",
19
"OBS_DEU_PT1H_T2M","2656","1982-01-19T17:00:00","-0.7","0","7",
20
"OBS_DEU_PT1H_T2M","2656","1982-01-20T17:00:00","-0.6","0","7",
21
"OBS_DEU_PT1H_T2M","2656","1982-01-21T17:00:00","0.2","0","7",
22
"OBS_DEU_PT1H_T2M","2656","1982-01-22T17:00:00","3.6","0","7",
23
"OBS_DEU_PT1H_T2M","2656","1982-01-23T17:00:00","2.5","0","7",
24
"OBS_DEU_PT1H_T2M","2656","1982-01-24T17:00:00","2.7","0","7",
25
"OBS_DEU_PT1H_T2M","2656","1982-01-25T17:00:00","3","0","7",
26
"OBS_DEU_PT1H_T2M","2656","1982-01-26T17:00:00","5.2","0","7",
27
"OBS_DEU_PT1H_T2M","2656","1982-01-27T17:00:00","3.7","0","7",
28
"OBS_DEU_PT1H_T2M","2656","1982-01-28T17:00:00","3.3","0","7",
29
"OBS_DEU_PT1H_T2M","2656","1982-01-29T17:00:00","5.2","0","7",
30
"OBS_DEU_PT1H_T2M","2656","1982-01-30T17:00:00","9.1","0","7",
31
"OBS_DEU_PT1H_T2M","2656","1982-01-31T17:00:00","6.5","0","7",
32
"OBS_DEU_PT1H_T2M","2656","1982-02-01T17:00:00","-0.2","0","7",
33
"OBS_DEU_PT1H_T2M","2656","1982-02-02T17:00:00","3.1","0","7",
34
"OBS_DEU_PT1H_T2M","2656","1982-02-03T17:00:00","1.5","0","7",
35
"OBS_DEU_PT1H_T2M","2656","1982-02-04T17:00:00","3.8","0","7",
36
"OBS_DEU_PT1H_T2M","2656","1982-02-05T17:00:00","4.9","0","7",
37
"OBS_DEU_PT1H_T2M","2656","1982-02-06T17:00:00","7","0","7",
38
"OBS_DEU_PT1H_T2M","2656","1982-02-07T17:00:00","8.8","0","7",
39
"OBS_DEU_PT1H_T2M","2656","1982-02-08T17:00:00","6.2","0","7",
40
"OBS_DEU_PT1H_T2M","2656","1982-02-09T17:00:00","8.3","0","7",
41
"OBS_DEU_PT1H_T2M","2656","1982-02-10T17:00:00","8.3","0","7",
42
"OBS_DEU_PT1H_T2M","2656","1982-02-11T17:00:00","11","0","7",
43
"OBS_DEU_PT1H_T2M","2656","1982-02-12T17:00:00","10.8","0","7",
44
"OBS_DEU_PT1H_T2M","2656","1982-02-13T17:00:00","9.7","0","7",
45
"OBS_DEU_PT1H_T2M","2656","1982-02-14T17:00:00","6","0","7",
46
"OBS_DEU_PT1H_T2M","2656","1982-02-15T17:00:00","5.9","0","7",
47
"OBS_DEU_PT1H_T2M","2656","1982-02-16T17:00:00","2.9","0","7",
48
"OBS_DEU_PT1H_T2M","2656","1982-02-17T17:00:00","3.6","0","7",
49
"OBS_DEU_PT1H_T2M","2656","1982-02-18T17:00:00","5","0","7",
50
"OBS_DEU_PT1H_T2M","2656","1982-02-19T17:00:00","-0.3","0","7",
51
"OBS_DEU_PT1H_T2M","2656","1982-02-20T17:00:00","4.9","0","7",
52
"OBS_DEU_PT1H_T2M","2656","1982-02-21T17:00:00","5.3","0","7",
53
"OBS_DEU_PT1H_T2M","2656","1982-02-22T17:00:00","6.7","0","7",
54
"OBS_DEU_PT1H_T2M","2656","1982-02-23T17:00:00","-0.2","0","7",
55
"OBS_DEU_PT1H_T2M","2656","1982-02-24T17:00:00","0.9","0","7",
56
"OBS_DEU_PT1H_T2M","2656","1982-02-25T17:00:00","0.5","0","7",
57
"OBS_DEU_PT1H_T2M","2656","1982-02-26T17:00:00","4","0","7",
58
"OBS_DEU_PT1H_T2M","2656","1982-02-27T17:00:00","6.1","0","7",
59
"OBS_DEU_PT1H_T2M","2656","1982-02-28T17:00:00","7.6","0","7",
60
"OBS_DEU_PT1H_T2M","2656","1982-03-01T17:00:00","13","0","7",
61
"OBS_DEU_PT1H_T2M","2656","1982-03-02T17:00:00","9","0","7",
62
"OBS_DEU_PT1H_T2M","2656","1982-03-03T17:00:00","12.5","0","7",
63
"OBS_DEU_PT1H_T2M","2656","1982-03-04T17:00:00","8.8","0","7",
64
"OBS_DEU_PT1H_T2M","2656","1982-03-05T17:00:00","4.6","0","7",
65
"OBS_DEU_PT1H_T2M","2656","1982-03-06T17:00:00","7.4","0","7",
66
"OBS_DEU_PT1H_T2M","2656","1982-03-07T17:00:00","7.2","0","7",
67
"OBS_DEU_PT1H_T2M","2656","1982-03-08T17:00:00","10","0","7",
68
"OBS_DEU_PT1H_T2M","2656","1982-03-09T17:00:00","8.6","0","7",
69
"OBS_DEU_PT1H_T2M","2656","1982-03-10T17:00:00","7.8","0","7",
70
"OBS_DEU_PT1H_T2M","2656","1982-03-11T17:00:00","5","0","7",
71
"OBS_DEU_PT1H_T2M","2656","1982-03-12T17:00:00","6.7","0","7",
72
"OBS_DEU_PT1H_T2M","2656","1982-03-13T17:00:00","5.4","0","7",
73
"OBS_DEU_PT1H_T2M","2656","1982-03-14T17:00:00","9.1","0","7",
74
"OBS_DEU_PT1H_T2M","2656","1982-03-15T17:00:00","13.5","0","7",
75
"OBS_DEU_PT1H_T2M","2656","1982-03-16T17:00:00","9.5","0","7",
76
"OBS_DEU_PT1H_T2M","2656","1982-03-17T17:00:00","8.5","0","7",
77
"OBS_DEU_PT1H_T2M","2656","1982-03-18T17:00:00","8.7","0","7",
78
"OBS_DEU_PT1H_T2M","2656","1982-03-19T17:00:00","8.2","0","7",
79
"OBS_DEU_PT1H_T2M","2656","1982-03-20T17:00:00","4.8","0","7",
80
"OBS_DEU_PT1H_T2M","2656","1982-03-21T17:00:00","5.2","0","7",
81
"OBS_DEU_PT1H_T2M","2656","1982-03-22T17:00:00","9.4","0","7",
82
"OBS_DEU_PT1H_T2M","2656","1982-03-23T17:00:00","9.5","0","7",
83
"OBS_DEU_PT1H_T2M","2656","1982-03-24T17:00:00","13.9","0","7",
84
"OBS_DEU_PT1H_T2M","2656","1982-03-25T17:00:00","16.4","0","7",
85
"OBS_DEU_PT1H_T2M","2656","1982-03-26T17:00:00","18","0","7",
86
"OBS_DEU_PT1H_T2M","2656","1982-03-27T17:00:00","19.7","0","7",
87
"OBS_DEU_PT1H_T2M","2656","1982-03-28T17:00:00","14.8","0","7",
88
"OBS_DEU_PT1H_T2M","2656","1982-03-29T17:00:00","8.2","0","7",
89
"OBS_DEU_PT1H_T2M","2656","1982-03-30T17:00:00","7.2","0","7",
90
"OBS_DEU_PT1H_T2M","2656","1982-03-31T17:00:00","10.3","0","7",
91
"OBS_DEU_PT1H_T2M","2656","1982-04-01T17:00:00","17.6","0","7",
92
"OBS_DEU_PT1H_T2M","2656","1982-04-02T17:00:00","14.6","0","7",
93
"OBS_DEU_PT1H_T2M","2656","1982-04-03T17:00:00","15.4","0","7",
94
"OBS_DEU_PT1H_T2M","2656","1982-04-04T17:00:00","16.5","0","7",
95
"OBS_DEU_PT1H_T2M","2656","1982-04-05T17:00:00","19.8","0","7",
96
"OBS_DEU_PT1H_T2M","2656","1982-04-06T17:00:00","13.4","0","7",
97
"OBS_DEU_PT1H_T2M","2656","1982-04-07T17:00:00","14.3","0","7",
98
"OBS_DEU_PT1H_T2M","2656","1982-04-08T17:00:00","4.9","0","7",
99
"OBS_DEU_PT1H_T2M","2656","1982-04-09T17:00:00","5.3","0","7",
100
"OBS_DEU_PT1H_T2M","2656","1982-04-10T17:00:00","8","0","7",
101
"OBS_DEU_PT1H_T2M","2656","1982-04-11T17:00:00","7","0","7",
102
"OBS_DEU_PT1H_T2M","2656","1982-04-12T17:00:00","2.5","0","7",
103
"OBS_DEU_PT1H_T2M","2656","1982-04-13T17:00:00","6.9","0","7",
104
"OBS_DEU_PT1H_T2M","2656","1982-04-14T17:00:00","10.9","0","7",
105
"OBS_DEU_PT1H_T2M","2656","1982-04-15T17:00:00","14.7","0","7",
106
"OBS_DEU_PT1H_T2M","2656","1982-04-16T17:00:00","18","0","7",
107
"OBS_DEU_PT1H_T2M","2656","1982-04-17T17:00:00","13.5","0","7",
108
"OBS_DEU_PT1H_T2M","2656","1982-04-18T17:00:00","14.8","0","7",
109
"OBS_DEU_PT1H_T2M","2656","1982-04-19T17:00:00","15.7","0","7",
110
"OBS_DEU_PT1H_T2M","2656","1982-04-20T17:00:00","15.5","0","7",
111
"OBS_DEU_PT1H_T2M","2656","1982-04-21T17:00:00","14.8","0","7",
112
"OBS_DEU_PT1H_T2M","2656","1982-04-22T17:00:00","16.9","0","7",
113
"OBS_DEU_PT1H_T2M","2656","1982-04-23T17:00:00","14.9","0","7",
114
"OBS_DEU_PT1H_T2M","2656","1982-04-24T17:00:00","9.9","0","7",
115
"OBS_DEU_PT1H_T2M","2656","1982-04-25T17:00:00","15.3","0","7",
116
"OBS_DEU_PT1H_T2M","2656","1982-04-26T17:00:00","13.1","0","7",
117
"OBS_DEU_PT1H_T2M","2656","1982-04-27T17:00:00","13.4","0","7",
118
"OBS_DEU_PT1H_T2M","2656","1982-04-28T17:00:00","11.9","0","7",
119
"OBS_DEU_PT1H_T2M","2656","1982-04-29T17:00:00","7","0","7",
120
"OBS_DEU_PT1H_T2M","2656","1982-04-30T17:00:00","10.2","0","7",
121
"OBS_DEU_PT1H_T2M","2656","1982-05-01T17:00:00","12","0","7",
122
"OBS_DEU_PT1H_T2M","2656","1982-05-02T17:00:00","12.6","0","7",
123
"OBS_DEU_PT1H_T2M","2656","1982-05-03T17:00:00","15.8","0","7",
124
"OBS_DEU_PT1H_T2M","2656","1982-05-04T17:00:00","14","0","7",
125
"OBS_DEU_PT1H_T2M","2656","1982-05-05T17:00:00","8.2","0","7",
126
"OBS_DEU_PT1H_T2M","2656","1982-05-06T17:00:00","15.1","0","7",
127
"OBS_DEU_PT1H_T2M","2656","1982-05-07T17:00:00","10.9","0","7",
128
"OBS_DEU_PT1H_T2M","2656","1982-05-08T17:00:00","15.2","0","7",
129
"OBS_DEU_PT1H_T2M","2656","1982-05-09T17:00:00","12.9","0","7",
130
"OBS_DEU_PT1H_T2M","2656","1982-05-10T17:00:00","14","0","7",
131
"OBS_DEU_PT1H_T2M","2656","1982-05-11T17:00:00","18.8","0","7",
132
"OBS_DEU_PT1H_T2M","2656","1982-05-12T17:00:00","20.1","0","7",
133
"OBS_DEU_PT1H_T2M","2656","1982-05-13T17:00:00","23.8","0","7",
134
"OBS_DEU_PT1H_T2M","2656","1982-05-14T17:00:00","25","0","7",
135
"OBS_DEU_PT1H_T2M","2656","1982-05-15T17:00:00","26.5","0","7",
136
"OBS_DEU_PT1H_T2M","2656","1982-05-16T17:00:00","23","0","7",
137
"OBS_DEU_PT1H_T2M","2656","1982-05-17T17:00:00","19.9","0","7",
138
"OBS_DEU_PT1H_T2M","2656","1982-05-18T17:00:00","17.4","0","7",
139
"OBS_DEU_PT1H_T2M","2656","1982-05-19T17:00:00","22","0","7",
140
"OBS_DEU_PT1H_T2M","2656","1982-05-20T17:00:00","16.3","0","7",
141
"OBS_DEU_PT1H_T2M","2656","1982-05-21T17:00:00","21.2","0","7",
142
"OBS_DEU_PT1H_T2M","2656","1982-05-22T17:00:00","17.2","0","7",
143
"OBS_DEU_PT1H_T2M","2656","1982-05-23T17:00:00","15.3","0","7",
144
"OBS_DEU_PT1H_T2M","2656","1982-05-24T17:00:00","17.4","0","7",
145
"OBS_DEU_PT1H_T2M","2656","1982-05-25T17:00:00","21.8","0","7",
146
"OBS_DEU_PT1H_T2M","2656","1982-05-26T17:00:00","26.5","0","7",
147
"OBS_DEU_PT1H_T2M","2656","1982-05-27T17:00:00","27","0","7",
148
"OBS_DEU_PT1H_T2M","2656","1982-05-28T17:00:00","18.7","0","7",
149
"OBS_DEU_PT1H_T2M","2656","1982-05-29T17:00:00","21.5","0","7",
150
"OBS_DEU_PT1H_T2M","2656","1982-05-30T17:00:00","24","0","7",
151
"OBS_DEU_PT1H_T2M","2656","1982-05-31T17:00:00","26.7","0","7",
152
"OBS_DEU_PT1H_T2M","2656","1982-06-01T17:00:00","30","0","7",
153
"OBS_DEU_PT1H_T2M","2656","1982-06-02T17:00:00","31","0","7",
154
"OBS_DEU_PT1H_T2M","2656","1982-06-03T17:00:00","31.7","0","7",
155
"OBS_DEU_PT1H_T2M","2656","1982-06-04T17:00:00","32.5","0","7",
156
"OBS_DEU_PT1H_T2M","2656","1982-06-05T17:00:00","21.3","0","7",
157
"OBS_DEU_PT1H_T2M","2656","1982-06-06T17:00:00","21.8","0","7",
158
"OBS_DEU_PT1H_T2M","2656","1982-06-07T17:00:00","20.7","0","7",
159
"OBS_DEU_PT1H_T2M","2656","1982-06-08T17:00:00","19.6","0","7",
160
"OBS_DEU_PT1H_T2M","2656","1982-06-09T17:00:00","23.8","0","7",
161
"OBS_DEU_PT1H_T2M","2656","1982-06-10T17:00:00","26.2","0","7",
162
"OBS_DEU_PT1H_T2M","2656","1982-06-11T17:00:00","17.3","0","7",
163
"OBS_DEU_PT1H_T2M","2656","1982-06-12T17:00:00","16.1","0","7",
164
"OBS_DEU_PT1H_T2M","2656","1982-06-13T17:00:00","13.8","0","7",
165
"OBS_DEU_PT1H_T2M","2656","1982-06-14T17:00:00","14.8","0","7",
166
"OBS_DEU_PT1H_T2M","2656","1982-06-15T17:00:00","17.3","0","7",
167
"OBS_DEU_PT1H_T2M","2656","1982-06-16T17:00:00","18.5","0","7",
168
"OBS_DEU_PT1H_T2M","2656","1982-06-17T17:00:00","20.8","0","7",
169
"OBS_DEU_PT1H_T2M","2656","1982-06-18T17:00:00","19","0","7",
170
"OBS_DEU_PT1H_T2M","2656","1982-06-19T17:00:00","16","0","7",
171
"OBS_DEU_PT1H_T2M","2656","1982-06-20T17:00:00","21.2","0","7",
172
"OBS_DEU_PT1H_T2M","2656","1982-06-21T17:00:00","22.5","0","7",
173
"OBS_DEU_PT1H_T2M","2656","1982-06-22T17:00:00","20.9","0","7",
174
"OBS_DEU_PT1H_T2M","2656","1982-06-23T17:00:00","18.9","0","7",
175
"OBS_DEU_PT1H_T2M","2656","1982-06-24T17:00:00","19.8","0","7",
176
"OBS_DEU_PT1H_T2M","2656","1982-06-25T17:00:00","23.6","0","7",
177
"OBS_DEU_PT1H_T2M","2656","1982-06-26T17:00:00","23","0","7",
178
"OBS_DEU_PT1H_T2M","2656","1982-06-27T17:00:00","19","0","7",
179
"OBS_DEU_PT1H_T2M","2656","1982-06-28T17:00:00","19.6","0","7",
180
"OBS_DEU_PT1H_T2M","2656","1982-06-29T17:00:00","14.7","0","7",
181
"OBS_DEU_PT1H_T2M","2656","1982-06-30T17:00:00","20.2","0","7",
182
"OBS_DEU_PT1H_T2M","2656","1982-07-01T17:00:00","18.8","0","7",
183
"OBS_DEU_PT1H_T2M","2656","1982-07-02T17:00:00","27.6","0","7",
184
"OBS_DEU_PT1H_T2M","2656","1982-07-03T17:00:00","21.7","0","7",
185
"OBS_DEU_PT1H_T2M","2656","1982-07-04T17:00:00","19.7","0","7",
186
"OBS_DEU_PT1H_T2M","2656","1982-07-05T17:00:00","22.3","0","7",
187
"OBS_DEU_PT1H_T2M","2656","1982-07-06T17:00:00","21.8","0","7",
188
"OBS_DEU_PT1H_T2M","2656","1982-07-07T17:00:00","24.2","0","7",
189
"OBS_DEU_PT1H_T2M","2656","1982-07-08T17:00:00","29.1","0","7",
190
"OBS_DEU_PT1H_T2M","2656","1982-07-09T17:00:00","32.6","0","7",
191
"OBS_DEU_PT1H_T2M","2656","1982-07-10T17:00:00","27.7","0","7",
192
"OBS_DEU_PT1H_T2M","2656","1982-07-11T17:00:00","30.6","0","7",
193
"OBS_DEU_PT1H_T2M","2656","1982-07-12T17:00:00","30.9","0","7",
194
"OBS_DEU_PT1H_T2M","2656","1982-07-13T17:00:00","30.2","0","7",
195
"OBS_DEU_PT1H_T2M","2656","1982-07-14T17:00:00","31.3","0","7",
196
"OBS_DEU_PT1H_T2M","2656","1982-07-15T17:00:00","29.5","0","7",
197
"OBS_DEU_PT1H_T2M","2656","1982-07-16T17:00:00","26.6","0","7",
198
"OBS_DEU_PT1H_T2M","2656","1982-07-17T17:00:00","24.5","0","7",
199
"OBS_DEU_PT1H_T2M","2656","1982-07-18T17:00:00","26.3","0","7",
200
"OBS_DEU_PT1H_T2M","2656","1982-07-19T17:00:00","25.1","0","7",
201
"OBS_DEU_PT1H_T2M","2656","1982-07-20T17:00:00","30.2","0","7",
202
"OBS_DEU_PT1H_T2M","2656","1982-07-21T17:00:00","20","0","7",
203
"OBS_DEU_PT1H_T2M","2656","1982-07-22T17:00:00","19.1","0","7",
204
"OBS_DEU_PT1H_T2M","2656","1982-07-23T17:00:00","21.5","0","7",
205
"OBS_DEU_PT1H_T2M","2656","1982-07-24T17:00:00","20.7","0","7",
206
"OBS_DEU_PT1H_T2M","2656","1982-07-25T17:00:00","18.2","0","7",
207
"OBS_DEU_PT1H_T2M","2656","1982-07-26T17:00:00","18.3","0","7",
208
"OBS_DEU_PT1H_T2M","2656","1982-07-27T17:00:00","18","0","7",
209
"OBS_DEU_PT1H_T2M","2656","1982-07-28T17:00:00","17","0","7",
210
"OBS_DEU_PT1H_T2M","2656","1982-07-29T17:00:00","27.2","0","7",
211
"OBS_DEU_PT1H_T2M","2656","1982-07-30T17:00:00","28.5","0","7",
212
"OBS_DEU_PT1H_T2M","2656","1982-07-31T17:00:00","21.2","0","7",
213
"OBS_DEU_PT1H_T2M","2656","1982-08-01T17:00:00","24.3","0","7",
214
"OBS_DEU_PT1H_T2M","2656","1982-08-02T17:00:00","28.8","0","7",
215
"OBS_DEU_PT1H_T2M","2656","1982-08-03T17:00:00","24.5","0","7",
216
"OBS_DEU_PT1H_T2M","2656","1982-08-04T17:00:00","25","0","7",
217
"OBS_DEU_PT1H_T2M","2656","1982-08-05T17:00:00","22","0","7",
218
"OBS_DEU_PT1H_T2M","2656","1982-08-06T17:00:00","26.4","0","7",
219
"OBS_DEU_PT1H_T2M","2656","1982-08-07T17:00:00","20.7","0","7",
220
"OBS_DEU_PT1H_T2M","2656","1982-08-08T17:00:00","20.3","0","7",
221
"OBS_DEU_PT1H_T2M","2656","1982-08-09T17:00:00","21.8","0","7",
222
"OBS_DEU_PT1H_T2M","2656","1982-08-10T17:00:00","20.7","0","7",
223
"OBS_DEU_PT1H_T2M","2656","1982-08-11T17:00:00","26.7","0","7",
224
"OBS_DEU_PT1H_T2M","2656","1982-08-12T17:00:00","31","0","7",
225
"OBS_DEU_PT1H_T2M","2656","1982-08-13T17:00:00","23.2","0","7",
226
"OBS_DEU_PT1H_T2M","2656","1982-08-14T17:00:00","23.8","0","7",
227
"OBS_DEU_PT1H_T2M","2656","1982-08-15T17:00:00","24.9","0","7",
228
"OBS_DEU_PT1H_T2M","2656","1982-08-16T17:00:00","26.2","0","7",
229
"OBS_DEU_PT1H_T2M","2656","1982-08-17T17:00:00","22.4","0","7",
230
"OBS_DEU_PT1H_T2M","2656","1982-08-18T17:00:00","25.9","0","7",
231
"OBS_DEU_PT1H_T2M","2656","1982-08-19T17:00:00","21.3","0","7",
232
"OBS_DEU_PT1H_T2M","2656","1982-08-20T17:00:00","16","0","7",
233
"OBS_DEU_PT1H_T2M","2656","1982-08-21T17:00:00","18","0","7",
234
"OBS_DEU_PT1H_T2M","2656","1982-08-22T17:00:00","20.1","0","7",
235
"OBS_DEU_PT1H_T2M","2656","1982-08-23T17:00:00","21.8","0","7",
236
"OBS_DEU_PT1H_T2M","2656","1982-08-24T17:00:00","19.8","0","7",
237
"OBS_DEU_PT1H_T2M","2656","1982-08-25T17:00:00","22.1","0","7",
238
"OBS_DEU_PT1H_T2M","2656","1982-08-26T17:00:00","24","0","7",
239
"OBS_DEU_PT1H_T2M","2656","1982-08-27T17:00:00","21.9","0","7",
240
"OBS_DEU_PT1H_T2M","2656","1982-08-28T17:00:00","21.2","0","7",
241
"OBS_DEU_PT1H_T2M","2656","1982-08-29T17:00:00","23.9","0","7",
242
"OBS_DEU_PT1H_T2M","2656","1982-08-30T17:00:00","24.6","0","7",
243
"OBS_DEU_PT1H_T2M","2656","1982-08-31T17:00:00","19.4","0","7",
244
"OBS_DEU_PT1H_T2M","2656","1982-09-01T17:00:00","19.7","0","7",
245
"OBS_DEU_PT1H_T2M","2656","1982-09-02T17:00:00","20.2","0","7",
246
"OBS_DEU_PT1H_T2M","2656","1982-09-03T17:00:00","23.3","0","7",
247
"OBS_DEU_PT1H_T2M","2656","1982-09-04T17:00:00","27","0","7",
248
"OBS_DEU_PT1H_T2M","2656","1982-09-05T17:00:00","28.8","0","7",
249
"OBS_DEU_PT1H_T2M","2656","1982-09-06T17:00:00","20.1","0","7",
250
"OBS_DEU_PT1H_T2M","2656","1982-09-07T17:00:00","20.5","0","7",
251
"OBS_DEU_PT1H_T2M","2656","1982-09-08T17:00:00","22.2","0","7",
252
"OBS_DEU_PT1H_T2M","2656","1982-09-09T17:00:00","24.2","0","7",
253
"OBS_DEU_PT1H_T2M","2656","1982-09-10T17:00:00","26.7","0","7",
254
"OBS_DEU_PT1H_T2M","2656","1982-09-11T17:00:00","25","0","7",
255
"OBS_DEU_PT1H_T2M","2656","1982-09-12T17:00:00","25.9","0","7",
256
"OBS_DEU_PT1H_T2M","2656","1982-09-13T17:00:00","20.5","0","7",
257
"OBS_DEU_PT1H_T2M","2656","1982-09-14T17:00:00","26.5","0","7",
258
"OBS_DEU_PT1H_T2M","2656","1982-09-15T17:00:00","27.6","0","7",
259
"OBS_DEU_PT1H_T2M","2656","1982-09-16T17:00:00","27.5","0","7",
260
"OBS_DEU_PT1H_T2M","2656","1982-09-17T17:00:00","29","0","7",
261
"OBS_DEU_PT1H_T2M","2656","1982-09-18T17:00:00","23.2","0","7",
262
"OBS_DEU_PT1H_T2M","2656","1982-09-19T17:00:00","26.2","0","7",
263
"OBS_DEU_PT1H_T2M","2656","1982-09-20T17:00:00","20","0","7",
264
"OBS_DEU_PT1H_T2M","2656","1982-09-21T17:00:00","22.9","0","7",
265
"OBS_DEU_PT1H_T2M","2656","1982-09-22T17:00:00","17.2","0","7",
266
"OBS_DEU_PT1H_T2M","2656","1982-09-23T17:00:00","15.5","0","7",
267
"OBS_DEU_PT1H_T2M","2656","1982-09-24T17:00:00","19.4","0","7",
268
"OBS_DEU_PT1H_T2M","2656","1982-09-25T17:00:00","21.8","0","7",
269
"OBS_DEU_PT1H_T2M","2656","1982-09-26T17:00:00","15.1","0","7",
270
"OBS_DEU_PT1H_T2M","2656","1982-09-27T17:00:00","19.4","0","7",
271
"OBS_DEU_PT1H_T2M","2656","1982-09-28T17:00:00","21","0","7",
272
"OBS_DEU_PT1H_T2M","2656","1982-09-29T17:00:00","22","0","7",
273
"OBS_DEU_PT1H_T2M","2656","1982-09-30T17:00:00","16.9","0","7",
274
"OBS_DEU_PT1H_T2M","2656","1982-10-01T17:00:00","15.3","0","7",
275
"OBS_DEU_PT1H_T2M","2656","1982-10-02T17:00:00","16.8","0","7",
276
"OBS_DEU_PT1H_T2M","2656","1982-10-03T17:00:00","17.4","0","7",
277
"OBS_DEU_PT1H_T2M","2656","1982-10-04T17:00:00","15.8","0","7",
278
"OBS_DEU_PT1H_T2M","2656","1982-10-05T17:00:00","14.3","0","7",
279
"OBS_DEU_PT1H_T2M","2656","1982-10-06T17:00:00","14","0","7",
280
"OBS_DEU_PT1H_T2M","2656","1982-10-07T17:00:00","11.9","0","7",
281
"OBS_DEU_PT1H_T2M","2656","1982-10-08T17:00:00","12.5","0","7",
282
"OBS_DEU_PT1H_T2M","2656","1982-10-09T17:00:00","12.6","0","7",
283
"OBS_DEU_PT1H_T2M","2656","1982-10-10T17:00:00","12.2","0","7",
284
"OBS_DEU_PT1H_T2M","2656","1982-10-11T17:00:00","11.6","0","7",
285
"OBS_DEU_PT1H_T2M","2656","1982-10-12T17:00:00","11.7","0","7",
286
"OBS_DEU_PT1H_T2M","2656","1982-10-13T17:00:00","13.2","0","7",
287
"OBS_DEU_PT1H_T2M","2656","1982-10-14T17:00:00","11.6","0","7",
288
"OBS_DEU_PT1H_T2M","2656","1982-10-15T17:00:00","11.7","0","7",
289
"OBS_DEU_PT1H_T2M","2656","1982-10-16T17:00:00","10.5","0","7",
290
"OBS_DEU_PT1H_T2M","2656","1982-10-17T17:00:00","12.8","0","7",
291
"OBS_DEU_PT1H_T2M","2656","1982-10-18T17:00:00","13.7","0","7",
292
"OBS_DEU_PT1H_T2M","2656","1982-10-19T17:00:00","14.5","0","7",
293
"OBS_DEU_PT1H_T2M","2656","1982-10-20T17:00:00","15.8","0","7",
294
"OBS_DEU_PT1H_T2M","2656","1982-10-21T17:00:00","13.7","0","7",
295
"OBS_DEU_PT1H_T2M","2656","1982-10-22T17:00:00","11.7","0","7",
296
"OBS_DEU_PT1H_T2M","2656","1982-10-23T17:00:00","11.2","0","7",
297
"OBS_DEU_PT1H_T2M","2656","1982-10-24T17:00:00","11.3","0","7",
298
"OBS_DEU_PT1H_T2M","2656","1982-10-25T17:00:00","9.6","0","7",
299
"OBS_DEU_PT1H_T2M","2656","1982-10-26T17:00:00","12.9","0","7",
300
"OBS_DEU_PT1H_T2M","2656","1982-10-27T17:00:00","14.7","0","7",
301
"OBS_DEU_PT1H_T2M","2656","1982-10-28T17:00:00","15","0","7",
302
"OBS_DEU_PT1H_T2M","2656","1982-10-29T17:00:00","9.8","0","7",
303
"OBS_DEU_PT1H_T2M","2656","1982-10-30T17:00:00","8.6","0","7",
304
"OBS_DEU_PT1H_T2M","2656","1982-10-31T17:00:00","10.4","0","7",
305
"OBS_DEU_PT1H_T2M","2656","1982-11-01T17:00:00","14.3","0","7",
306
"OBS_DEU_PT1H_T2M","2656","1982-11-02T17:00:00","14.1","0","7",
307
"OBS_DEU_PT1H_T2M","2656","1982-11-03T17:00:00","11.2","0","7",
308
"OBS_DEU_PT1H_T2M","2656","1982-11-04T17:00:00","10.6","0","7",
309
"OBS_DEU_PT1H_T2M","2656","1982-11-05T17:00:00","10.8","0","7",
310
"OBS_DEU_PT1H_T2M","2656","1982-11-06T17:00:00","6.8","0","7",
311
"OBS_DEU_PT1H_T2M","2656","1982-11-07T17:00:00","8.2","0","7",
312
"OBS_DEU_PT1H_T2M","2656","1982-11-08T17:00:00","13.5","0","7",
313
"OBS_DEU_PT1H_T2M","2656","1982-11-09T17:00:00","13.6","0","7",
314
"OBS_DEU_PT1H_T2M","2656","1982-11-10T17:00:00","12.4","0","7",
315
"OBS_DEU_PT1H_T2M","2656","1982-11-11T17:00:00","12.7","0","7",
316
"OBS_DEU_PT1H_T2M","2656","1982-11-12T17:00:00","12.3","0","7",
317
"OBS_DEU_PT1H_T2M","2656","1982-11-13T17:00:00","8.1","0","7",
318
"OBS_DEU_PT1H_T2M","2656","1982-11-14T17:00:00","6.4","0","7",
319
"OBS_DEU_PT1H_T2M","2656","1982-11-15T17:00:00","5.3","0","7",
320
"OBS_DEU_PT1H_T2M","2656","1982-11-16T17:00:00","5.1","0","7",
321
"OBS_DEU_PT1H_T2M","2656","1982-11-17T17:00:00","7","0","7",
322
"OBS_DEU_PT1H_T2M","2656","1982-11-18T17:00:00","12.2","0","7",
323
"OBS_DEU_PT1H_T2M","2656","1982-11-19T17:00:00","9.1","0","7",
324
"OBS_DEU_PT1H_T2M","2656","1982-11-20T17:00:00","8.5","0","7",
325
"OBS_DEU_PT1H_T2M","2656","1982-11-21T17:00:00","7","0","7",
326
"OBS_DEU_PT1H_T2M","2656","1982-11-22T17:00:00","8.2","0","7",
327
"OBS_DEU_PT1H_T2M","2656","1982-11-23T17:00:00","13.9","0","7",
328
"OBS_DEU_PT1H_T2M","2656","1982-11-24T17:00:00","9.4","0","7",
329
"OBS_DEU_PT1H_T2M","2656","1982-11-25T17:00:00","10.3","0","7",
330
"OBS_DEU_PT1H_T2M","2656","1982-11-26T17:00:00","8","0","7",
331
"OBS_DEU_PT1H_T2M","2656","1982-11-27T17:00:00","7.3","0","7",
332
"OBS_DEU_PT1H_T2M","2656","1982-11-28T17:00:00","4.9","0","7",
333
"OBS_DEU_PT1H_T2M","2656","1982-11-29T17:00:00","3.1","0","7",
334
"OBS_DEU_PT1H_T2M","2656","1982-11-30T17:00:00","3","0","7",
335
"OBS_DEU_PT1H_T2M","2656","1982-12-01T17:00:00","2.8","0","7",
336
"OBS_DEU_PT1H_T2M","2656","1982-12-02T17:00:00","3.5","0","7",
337
"OBS_DEU_PT1H_T2M","2656","1982-12-03T17:00:00","4.6","0","7",
338
"OBS_DEU_PT1H_T2M","2656","1982-12-04T17:00:00","3.9","0","7",
339
"OBS_DEU_PT1H_T2M","2656","1982-12-05T17:00:00","3","0","7",
340
"OBS_DEU_PT1H_T2M","2656","1982-12-06T17:00:00","6.6","0","7",
341
"OBS_DEU_PT1H_T2M","2656","1982-12-07T17:00:00","6.9","0","7",
342
"OBS_DEU_PT1H_T2M","2656","1982-12-08T17:00:00","9.6","0","7",
343
"OBS_DEU_PT1H_T2M","2656","1982-12-09T17:00:00","8.1","0","7",
344
"OBS_DEU_PT1H_T2M","2656","1982-12-10T17:00:00","6.7","0","7",
345
"OBS_DEU_PT1H_T2M","2656","1982-12-11T17:00:00","6","0","7",
346
"OBS_DEU_PT1H_T2M","2656","1982-12-12T17:00:00","2.4","0","7",
347
"OBS_DEU_PT1H_T2M","2656","1982-12-13T17:00:00","4.3","0","7",
348
"OBS_DEU_PT1H_T2M","2656","1982-12-14T17:00:00","1.6","0","7",
349
"OBS_DEU_PT1H_T2M","2656","1982-12-15T17:00:00","9.7","0","7",
350
"OBS_DEU_PT1H_T2M","2656","1982-12-16T17:00:00","7.5","0","7",
351
"OBS_DEU_PT1H_T2M","2656","1982-12-17T17:00:00","4.3","0","7",
352
"OBS_DEU_PT1H_T2M","2656","1982-12-18T17:00:00","3","0","7",
353
"OBS_DEU_PT1H_T2M","2656","1982-12-19T17:00:00","2","0","7",
354
"OBS_DEU_PT1H_T2M","2656","1982-12-20T17:00:00","5.7","0","7",
355
"OBS_DEU_PT1H_T2M","2656","1982-12-21T17:00:00","6.2","0","7",
356
"OBS_DEU_PT1H_T2M","2656","1982-12-22T17:00:00","4.7","0","7",
357
"OBS_DEU_PT1H_T2M","2656","1982-12-23T17:00:00","1.7","0","7",
358
"OBS_DEU_PT1H_T2M","2656","1982-12-24T17:00:00","1.5","0","7",
359
"OBS_DEU_PT1H_T2M","2656","1982-12-25T17:00:00","3.4","0","7",
360
"OBS_DEU_PT1H_T2M","2656","1982-12-26T17:00:00","5.7","0","7",
361
"OBS_DEU_PT1H_T2M","2656","1982-12-27T17:00:00","8.3","0","7",
362
"OBS_DEU_PT1H_T2M","2656","1982-12-28T17:00:00","6.1","0","7",
363
"OBS_DEU_PT1H_T2M","2656","1982-12-29T17:00:00","2.8","0","7",
364
"OBS_DEU_PT1H_T2M","2656","1982-12-30T17:00:00","3.2","0","7",
365
"OBS_DEU_PT1H_T2M","2656","1982-12-31T17:00:00","-1.6","0","7",

So, und jezt macht wegen der Länge ein paar Anfeindungen :D
Gast #6934021
Tja, jetzt hast du es eh schon gelöst.

Wenn du die Daten ohnehin in Excel hast wäre mein Ansatz gewesen:
- Filter auf die Spalte mit den Zeitstempeln
- alle auswählen, die auf 17:00:00 enden
- die selektierten Werte kopieren und anderswo weiterverwenden...
Angehängte Dateien:
Gast #6934570
Hi Achim,
danke für deine Hilfe, aber allein schon an dieser kleinen Aufgabe 
scheitere ich schon, da ich die Befehle ,die du beschrieben hast nicht 
umsetzen kann. Excel ist eben ein totaler blinder Fleck von mir. Sorry
Gast #6934801
Kalli R. schrieb:
> danke für deine Hilfe, aber allein schon an dieser kleinen Aufgabe
> scheitere ich schon, da ich die Befehle ,die du beschrieben hast nicht
> umsetzen kann. Excel ist eben ein totaler blinder Fleck von mir. Sorry

Wenn du probieren willst, das mit den Bordmitteln von Exceln 
nachzuvollziehen, dann hier mal der Versuch einer Schritt für Schritt 
Anleitung. Die Zahlen im Text beziehen sich auf die Bilder bzw. die 
Markierungen in den Bildern.

Das csv in Excel öffnen/importieren. Dabei darauf achten, dass
1 das richtige Trennzeichen ausgewählt wird und dass
2 für Spalten ein "ungefährlicher" Datentyp ausgewählt wird. (Mit dem 
Datentyp "Standard" kann es sonst leicht dazu kommen, dass eine 
Temperatur 16.8 (Grad) als Datum (1. August) interpretiert wird.)

Links oben auf den Zeilenstart klicken (3A), um die ganz Zeile zu 
markieren. Dann im Menue Daten den Befehl Filtern auswählen (3B).

Den Filter für die Zeitstempel-Spalte anwählen (4A), die passende 
Filtermaske eingeben (4B) und bestätigen (4C).

Damit werden dir nur nch die gewünschten Daten angezeigt. Die am Block 
markieren, mit Ctrl-C kopieren, und z.B. wieder neu als csv-Datei 
speichern (und dabei diverse Warnungen wegklicken). Das Ergebnis findest 
du im letzten Anhang dieses Beitrags.
Angehängte Dateien:

Antwort schreiben

Eine eigene Frage? Dieser Thread ist über 4 Jahre alt. Stell sie in einem eigenen Thread – dort lesen mehr Leute mit, und sie wird öfter und schneller beantwortet.

Neuen Thread starten

Eine Lösung, Ergänzung oder Rückmeldung zu diesem Thread? Dann antworte hier.

Formatierung
  • [c]C-Code[/c]
  • [code]Code in anderen Sprachen, ASCII-Zeichnungen[/code]
  • [math]Formel in LaTeX-Syntax[/math]
  • [[Titel]] – Link zu einem Artikel
  • Verweis auf einen anderen Beitrag: Rechtsklick auf dessen Beitrags-ID (#8078628), „Adresse kopieren“, in den Text einfügen

Mehr zur Formatierung

Längeren Sourcecode als Anhang, nicht in den Text. JPG nur für Fotos und Scans; Zeichnungen und Screenshots als PNG oder GIF. Siehe Bildformate.

Schon registriert? Anmelden

Wird nicht angezeigt. Wir schicken dir einen Link; sobald du damit bestätigst, erscheint dein Beitrag.

Mit dem Abschicken legst du einen kostenlosen Account an und erkennst die Nutzungsbedingungen und die Datenschutzerklärung an.