質問編集履歴
3
修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -66,7 +66,7 @@
|
|
|
66
66
|
|
|
67
67
|
2019/5/14,BBB,8:49:00,8:51:00,18,0:01:00
|
|
68
68
|
|
|
69
|
-
2019/5/14,CCC,
|
|
69
|
+
2019/5/14,CCC,0:00:00,11:26:00,19,2:14:36
|
|
70
70
|
|
|
71
71
|
2019/5/13,,8:28:00,17:04:00,15,7:33:15
|
|
72
72
|
|
2
修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -16,16 +16,6 @@
|
|
|
16
16
|
|
|
17
17
|
|
|
18
18
|
|
|
19
|
-
②OFF1の値が[23:59:59]であっても、翌日のレコードがなければ[0:00:00]を入れない
|
|
20
|
-
|
|
21
|
-
（2019/5/12,,8:30:00,23:59:59,19,11:43:57 → 2019/5/14,CCC,8:38:00,11:26:00,19,2:14:36
|
|
22
|
-
|
|
23
|
-
5/13のレコードがないので、どこも[]に設定しない）
|
|
24
|
-
|
|
25
|
-
|
|
26
|
-
|
|
27
|
-
|
|
28
|
-
|
|
29
19
|
### 元csv:csv_tmp1.csv
|
|
30
20
|
|
|
31
21
|
日付,表示名,ON1,OFF1,u_no,act_time
|
1
修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -268,17 +268,17 @@
|
|
|
268
268
|
|
|
269
269
|
ckck2=(d(0, j))
|
|
270
270
|
|
|
271
|
-
msgbox ckck2
|
|
271
|
+
'msgbox ckck2
|
|
272
|
-
|
|
272
|
+
|
|
273
|
-
msgbox n
|
|
273
|
+
'msgbox n
|
|
274
|
-
|
|
275
|
-
|
|
276
|
-
|
|
274
|
+
|
|
275
|
+
|
|
276
|
+
|
|
277
|
-
If n = DateValue(d(0, j)) and d(3, j) = "23:59:59" and d(4, j) = d(4, i) Then
|
|
277
|
+
'If n = DateValue(d(0, j)) and d(3, j) = "23:59:59" and d(4, j) = d(4, i) Then
|
|
278
|
+
|
|
278
|
-
|
|
279
|
+
If d(3, j) = "23:59:59" and d(4, j) = d(4, i) Then
|
|
279
|
-
|
|
280
|
-
|
|
280
|
+
|
|
281
|
-
msgbox n
|
|
281
|
+
'msgbox n
|
|
282
282
|
|
|
283
283
|
|
|
284
284
|
|