入力
出力
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnEAABJxAfPceo4AAAASdEVYdFNvZnR3YXJlAEdyZWVuc2hvdF5VCAUAAA0cSURBVHhe7Z3fjhXHEYf9Bs4bxG+A38B+A/sN7DdI3sBccYcSKXBhCQkuLPliibGEfcNeJGKvFiFhNgoKijFai+BVEPJCIrAlS+TbU72V2uo/02dn5uyedX1qjU7XVPd0D1O/qZ4zZ3nrTRAEwUoIuQmCYEWE3ARBsCJORm7+8uQ/Nx7tp0qwDjx58uTu3bu7u7upHgTLs2q5efzi5/e/+PatP31DSaZgHQi5CcazUrm59+zVbz79m2jNsnLz40+/nN/eQ6oQrGQKVkjITTCelcrNJ9s/qNYsJTdWp1iIJWuwQkJugvGsh9y8/emOtgq5ORFCboLxrIfc2FYhNydCyE0wnpCboIuQm2A8ITdBFyE3wXhCboIuQm6C8YTcBF2E3ATjGZCbH3/65Y/fPPt48/v3v/jWvjJDeffzh9jZe+/Zq+Q9xMnKDeM8v733+9v/Yi5s+fzloxdpXzBEyE0wngG5+eCr72yo18o71x4QwIMv4C0lN3+49290gYKu2VZoHEphy6AAXX3w3GmlFuz0gKom1xLs/euT/0pJpsXvMES5RLySdQG71L/ds6JNrHbzWftJpgp2hDO9BhlyE4xnQG4+2tx18dkohG5qVmEpubGe7fLen/+Z2mQQh06tigWfhi5YzUUE8URi1CIluS6wdk5gstZBDdX/t9f+nqxH3zb63e0nyZrh5thzxGMQchOMZ0BuuOty0RPPhBxiYQsWGw9S2okGraxzslawnu3SkJtzn/8jd5bi7ERsapNhnZl1nii5AVh5GpRgsIPkFCXrIr9TO6V2blEi67bW2c3+/j6HAD4kU5PXr1+LPyRTnU43RQbDIVJ9wbKd7O3tuU7EwjbVSxR9BluBjNmdPSzWKNUexH9Cxj4qdgoyodzkSlErNkQt7nBUbQrDZxeotX5ybXLFJRQ3Hu3bve3fvqMO1tmJhT0JrFjzFIwTrg6U2hTGM6vcEAk3b968fPnyBQPVzc1NF+0Cxq2trStXriTXQ7Ds7OwkpwzxuXXrVqo3efjwofi7KYuR0aZ6k9u3b4u/7eSzzz7DwjbVSxR9Fj1duH//fqqXkCOyTfUF0lCNUu1BTsLFixcbMscucb5z504y1RkrN+5yn1BulKUOobgwJlNIO45iFYd4Ttaj5HJDWofEMJJ7z16xzVWANZE6t1c3NoVxWRLQv+6luCUVx2XMuhdtSjtmYD65IX7kei3Ctc5Fn1wXcH1jTLsXEJbWgugUwyPtvnBhMEeAS5cuiXNRbmDwVKCJOqoJ5aYd/NPKDc6Dox10sJxZubE6Yh+IOIhYdaMUO3dyQ1TbB7pFXN6U65Fihenqg+fJanAnzY7QHWVwVGOYSW64JS4u7AOIBxtIHIskAvvGxkYyHdUa9lp/UiR6kL3FmJRWMBgbVgFrcjPYiUS+MKHcAHpaTPpADqrKIkgrZ1QYmzgU/3E5q7K3mFXpiWoooOXMyo19rlRLbQSrJowwWQ3WgW57otrlVkUdAZu80HNNlYpLKndaiiOfkDnkhmtULtbGHRu7DS1dQLmUR8FfFAfPZDoEo0pVYyKalUiC4zwXrVM/jXVNo5ORciPd1lZzk8sNSJ+sbZ3G6Rw716dwNuXm2KP64KvvktVg5SZf79SwGlHsFmx60lhzuenIksr2T4rUSKAmYQ65kaCCznuj3ktrkSNo/Dg5ECOxwZbgSdYMiS7cZHhuygddLAbAttGJ5GVs806KUuIo+mABPQlFsZOBufMj/rWTpqer8Y8roul6kGOhOE6GGpxNuXHf6SRrBTuqopocT27s19uUohzYFKw9L7du+vDrx7bac05GMrncaJZeu1HnSGrTc303wlXvycVwlb1yCOmkKDfaSTGGZWo48CHvpDg2R9EHC/BBtAxymRYJcKMS5+JQoUdu1IcZiUX/+WppZpGzKTdkCrZJslaYSW7QF21FyddT9gusxtMlgd7sUx5bJNmZm8nlRu/SndcrES7+PfKkj4RSfYFaGrdliWSJzFwp4KCLRScy/mN0UpQSR9EHC/CBI4ry5gscmZpTlkW7UXIDGxsb+Fy/fl2qPbPI6ZIbrvUvH704v73HTVXeo9XiXqI7JXJjBYLixuyK/XJnQrkBq3ocKFkPsXt7JMOdBykrWEYJk8uNBAZ0rqQ0KmphYymGkFjkc3F1IHdsdkkMS0S5KR90cbQT9+RCU5taJz2BWvTBAvJZH1Fp/AtyVt28Fu3Gyg3zkiPipk002elkQG4ev/j5483v3SXeKKdTbvrLtHLjXsCx79S43Me9blPDLakoK/sPLeaTm1QfQi/xWthY1NkOWCzyWXMTGzByA9dFVq4UcNDFYSd6FNuJtNKXUPJOilLiKPpggVSpPMmSs+pOUe5mKZ6rIpIzMioZXs8/hKMlN+T/tZ8a1coccuMegswqN8XntceWG7ArIPsFmZ3Uue73ZZzy9ryyPBXzyU3nHVKjoucqL4aQWFLlMKR1aSZNSFikCuLgpnzQRdaJphg9nYiFbaqXKPpggVRZII+9QfuXs+pOkfjUzpuMGdxMi+g3g5oDLkVVbrjfOq0hKtALCndUrnst1odqal/ieHLjWrUPIViBYNg61MGS2h9ljNzYwdvfSdg+88c6NZiLtpJC/2nfzMwnN519snwQ/x65kddhwWqZWFLFhJms5mq64Ia3aPH/TnRU4iZNND+CWrdsU71E0QcLpMoh7vH53HKjJ3apJ8RKVW7sD3/aL5uoG6UWscKJyM34FGCM3LgXcGTR5IydD1/cedAy69t9yuRyoxduj3wI8qwkf6EmR277NsuAxdGOhKusnohqWZi48JaYd1M+6OJoJ/JgGGeJ28FO9KCpXkJaOR8skCqHoKfySEVOy9xys5RzTlVu7AXdfk3Oep5CuaEk63EZIzdgm8uZtN/TN163sdgXAl1p/Lh0QiaXG5A4aby94pDAHrzWuc9Lz7pQEqRtqiwgVsUo/u6hda4UsHD3nehE2Dr/vBNRBJqkegkR1qJqpIpBhRuRXUu5IaTtBd2O8H7PlcmNazLyu5uRcmMf08jPsuyaqPNZr21CsuleLGK+yW825pAbiQ2oRYJD1YE7eePBgaqSXUmBGFPlEH384bQJOuUGdCIuH4G8E11/2TWXRUPayZ8YU+UoOgtZW6233CRrBeu5lNwcbxHRIzdu/P0PR4qMlBumaV/ns+oz+LqN4MRFUiQ7KsrcS6o55EbTEKj9nphAskKggU1cOTUBOrx+/bo45B2KPVUOkTFA3lu/3CzbiRjxz88nEoOdvblyHRy4IjcgfQrrLTftCO/3PIZwgAu2nnTAfc2cv/OyFCPlBtxrh1p6Xrdxz+x1ANitis29pJpDbkCjC1iMoBEcQuCzLE9cGGvyAojL1tYWqwm22LWrPFUB2ZUqBsQCUsXQLzewVCdMR4fKFHZ2dhYz3t3c3BQje11qA7IrVTI4uva5ZnLjnhQ0sgP31LOtIPbGTul8bOG0r7OVi/AxCc54uXFT0CJPjtvYo6Mvtkkx65mJmeQGiCtZAhQhXPPAYxkiTzdysNcWKeKQKh0sJTc1ip1AY9ZMIZ8yyN5UKaFasGZyA/bO+c61B3lgIEn5G4DcY+XvB5NQ5BGeP+/EU3omH5EXl/NFgVM0iv5dZLb9rXArLt8ahxbGyw3kP0E41/G6jROU/BmNHRtJkJyWOZhPbgQyFFISgpNbNPHGB5ZR7cPRhBDa2NjAmS2fsaR9JXCDVOmAAeDvIn+SThSUkZGL7jBrPte0EnoOzRnIO5GGtZ4ZmzjUBmlZyjmnKjf5C6woiPwHBh9+/di++F8rxW+gaz/80TL4m+xiKS4l3NpNCp4yEflBhp1IbT0yidzkgxlMuNAOu4wqypNT1ZHLxgZzy03wa6AqN9zzB6WBgk9DC/J8obas0FIUqTwtyktyPUrtoUmtFNOfSeQmz7aKx7K4E1tLvpyQzbSkCrkJxlOVG+D6zl9jtYUMiJghkOzKS4t70KBwVy/6S6n9aZgbj/YbrRoLkzxNa5TigCeRG7D9DD6Bcs+50JS0o4T9Z5ppSRVyE4ynJTcC1z0SoJkOMU/YcAu1N2c+Ez/qw9VPkDcuevzpgW7pSjqkEFG1G7hQbMWBBr+rYiQMr6FWjLwxYAYmbdkOroAaMHI94uCYmalMUOaYrBU4b+pMaZ/G4xFyE4xnWG7OEsQhcY58SCGkWdzNkQvkcBTVGmQrWdeHkJtgPL8uuTlB7JpuMFs5hYTcBOMJuVkFLAPtd0yryaemJeQmGE/IzSpg4aZa896Ih80nSMhNMJ6Qm9m59+yVTW3aL16fWkJugvGE3MwIa6jz23tWa9Y0tYGQm2A8ITcTg6AgK+8e/YvxUt6u/8d1p5+Qm2A8ITcT4yRGC1ozx+swKyPkJhhPyM3EOJWR8tHm7vrmNULITTCekJuJ0fee2X6y/cPVB8/X8WvvnJcvXz59+jT/81FB0E/ITRAEKyLkJgiCFRFyEwTBSnjz5n+Bsg0wC+hiuAAAAABJRU5ErkJggg==
ウィークリーチャレンジ #76
ユースケース:
配送センターがパッケージを受け取りました。受け取った時点で、パッケージがスキャンされ、タイムスタンプが到着日時をキャプチャします。同社は、パッケージが施設にとどまっている時間を短縮しようとしており、そのために、パッケージが施設にとどまっている時間を分析しようとしています。
このチャレンジの目的は、タイムスタンプの日/時刻と現在時刻フィールドの間のデルタ(差)を計算することです (このフィールドには、このチャレンジの作成日時があり、時間が進むにつれて変更されます)。日、時間、分、および秒のユニークなフィールドを作成しましょう。
HPNZGSDMQMX
2020-07-09 11:07:47
2020-07-14 08:24:35
F5NZRZ3YVRD
2020-07-09 08:40:07
2020-07-14 08:24:35
FHNBTNMV3MP
2020-07-08 12:26:56
2020-07-14 08:24:35
ZHN7W97Z955
2020-07-08 13:26:38
2020-07-14 08:24:35
ZKNWRVBTXZ2
2020-07-08 13:25:42
2020-07-14 08:24:35
HGNYD3V77CQ
2020-07-07 19:13:24
2020-07-14 08:24:35
HJN6JRBWR3Z
2020-07-08 11:39:52
2020-07-14 08:24:35
KNNHPH2YTPX
2020-07-07 14:35:10
2020-07-14 08:24:35
JPNX3YQ5GV3
2020-07-08 10:35:18
2020-07-14 08:24:35
ZFN8QQ3RSP7
2020-07-07 20:00:46
2020-07-14 08:24:35
ZFN8QQ3RSP7
2020-07-09 13:31:24
2020-07-14 08:24:35
GTNVDYQPLXT
2020-07-08 13:26:46
2020-07-14 08:24:35
ZPNZYQRYRP9
2020-07-07 14:13:24
2020-07-14 08:24:35
N5N8T5CKSXY
2020-07-07 17:06:37
2020-07-14 08:24:35
HNNDMTZHK7R
2020-07-08 13:01:44
2020-07-14 08:24:35
ZDNF7FBYH54
2020-07-08 08:41:20
2020-07-14 08:24:35
N9NJ275XPMZ
2020-07-09 11:21:16
2020-07-14 08:24:35
KMNC8ML97ZK
2020-07-07 17:10:34
2020-07-14 08:24:35
KMNC8ML97ZK
2020-07-07 17:42:25
2020-07-14 08:24:35
JYNLNB87C73
2020-07-07 14:55:58
2020-07-14 08:24:35
N4N4QCSJWQX
2020-07-07 15:48:03
2020-07-14 08:24:35
P8N4TSH8SL3
2020-07-08 16:37:45
2020-07-14 08:24:35
LHNKDQDD8G3
2020-07-07 20:01:11
2020-07-14 08:24:35
LHNKDQDD8G3
2020-07-09 13:31:40
2020-07-14 08:24:35
PJNT3NKM6F4
2020-07-07 19:45:35
2020-07-14 08:24:35
G9NNGTMNLPJ
2020-07-08 08:44:18
2020-07-14 08:24:35
G9NNGTMNLPJ
2020-07-08 16:54:40
2020-07-14 08:24:35
F2NCWKFQ5FS
2020-07-09 11:12:11
2020-07-14 08:24:35
MDNSZPY6MLY
2020-07-08 16:17:20
2020-07-14 08:24:35
K7NW774HZMJ
2020-07-07 14:15:57
2020-07-14 08:24:35
K7NW774HZMJ
2020-07-07 19:13:16
2020-07-14 08:24:35
N6ND7Z47PGT
2020-07-08 11:40:25
2020-07-14 08:24:35
N6ND7Z47PGT
2020-07-08 12:26:32
2020-07-14 08:24:35
N6ND7Z47PGT
2020-07-08 12:26:46
2020-07-14 08:24:35
Z2NJRFDVDN6
2020-07-08 10:35:28
2020-07-14 08:24:35
VWN6ZZ99L3Q
2020-07-08 14:47:01
2020-07-14 08:24:35
GMN8T99TPMR
2020-07-07 18:20:02
2020-07-14 08:24:35
NTNS4MJ672W
2020-07-07 18:06:19
2020-07-14 08:24:35
V7NLG9GJ2B9
2020-07-09 12:52:35
2020-07-14 08:24:35
LGNFMNWML96
2020-07-09 11:37:13
2020-07-14 08:24:35
NMNP8S4HMDC
2020-07-08 14:34:21
2020-07-14 08:24:35
J6NT6YM6BYF
2020-07-09 13:08:53
2020-07-14 08:24:35
VBNHT8DPRD5
2020-07-08 15:11:35
2020-07-14 08:24:35
onsite095
2020-07-09 12:54:48
2020-07-14 08:24:35
HVN9P6WBWPD
2020-07-07 17:38:41
2020-07-14 08:24:35
KMNW7B2ZXV4
2020-07-08 13:13:04
2020-07-14 08:24:35
C:\Users\SGRUNE~1\AppData\Local\Temp\Engine_35384_2b536d2fbec3499190d8c4fa254e95e7_\Engine_2592_349aa8da187447939f7291a27905c3a9_.yxdb
HPNZGSDMQMX
2020-07-09 11:07:47
2020-07-14 08:24:35
4
21
16
48
F5NZRZ3YVRD
2020-07-09 08:40:07
2020-07-14 08:24:35
4
23
44
28
FHNBTNMV3MP
2020-07-08 12:26:56
2020-07-14 08:24:35
5
19
57
39
ZHN7W97Z955
2020-07-08 13:26:38
2020-07-14 08:24:35
5
18
57
57
ZKNWRVBTXZ2
2020-07-08 13:25:42
2020-07-14 08:24:35
5
18
58
53
HGNYD3V77CQ
2020-07-07 19:13:24
2020-07-14 08:24:35
6
13
11
11
HJN6JRBWR3Z
2020-07-08 11:39:52
2020-07-14 08:24:35
5
20
44
43
KNNHPH2YTPX
2020-07-07 14:35:10
2020-07-14 08:24:35
6
17
49
25
JPNX3YQ5GV3
2020-07-08 10:35:18
2020-07-14 08:24:35
5
21
49
17
ZFN8QQ3RSP7
2020-07-07 20:00:46
2020-07-14 08:24:35
6
12
23
49
ZFN8QQ3RSP7
2020-07-09 13:31:24
2020-07-14 08:24:35
4
18
53
11
GTNVDYQPLXT
2020-07-08 13:26:46
2020-07-14 08:24:35
5
18
57
49
ZPNZYQRYRP9
2020-07-07 14:13:24
2020-07-14 08:24:35
6
18
11
11
N5N8T5CKSXY
2020-07-07 17:06:37
2020-07-14 08:24:35
6
15
17
58
HNNDMTZHK7R
2020-07-08 13:01:44
2020-07-14 08:24:35
5
19
22
51
ZDNF7FBYH54
2020-07-08 08:41:20
2020-07-14 08:24:35
5
23
43
15
N9NJ275XPMZ
2020-07-09 11:21:16
2020-07-14 08:24:35
4
21
3
19
KMNC8ML97ZK
2020-07-07 17:10:34
2020-07-14 08:24:35
6
15
14
1
KMNC8ML97ZK
2020-07-07 17:42:25
2020-07-14 08:24:35
6
14
42
10
JYNLNB87C73
2020-07-07 14:55:58
2020-07-14 08:24:35
6
17
28
37
N4N4QCSJWQX
2020-07-07 15:48:03
2020-07-14 08:24:35
6
16
36
32
P8N4TSH8SL3
2020-07-08 16:37:45
2020-07-14 08:24:35
5
15
46
50
LHNKDQDD8G3
2020-07-07 20:01:11
2020-07-14 08:24:35
6
12
23
24
LHNKDQDD8G3
2020-07-09 13:31:40
2020-07-14 08:24:35
4
18
52
55
PJNT3NKM6F4
2020-07-07 19:45:35
2020-07-14 08:24:35
6
12
39
0
G9NNGTMNLPJ
2020-07-08 08:44:18
2020-07-14 08:24:35
5
23
40
17
G9NNGTMNLPJ
2020-07-08 16:54:40
2020-07-14 08:24:35
5
15
29
55
F2NCWKFQ5FS
2020-07-09 11:12:11
2020-07-14 08:24:35
4
21
12
24
MDNSZPY6MLY
2020-07-08 16:17:20
2020-07-14 08:24:35
5
16
7
15
K7NW774HZMJ
2020-07-07 14:15:57
2020-07-14 08:24:35
6
18
8
38
K7NW774HZMJ
2020-07-07 19:13:16
2020-07-14 08:24:35
6
13
11
19
N6ND7Z47PGT
2020-07-08 11:40:25
2020-07-14 08:24:35
5
20
44
10
N6ND7Z47PGT
2020-07-08 12:26:32
2020-07-14 08:24:35
5
19
58
3
N6ND7Z47PGT
2020-07-08 12:26:46
2020-07-14 08:24:35
5
19
57
49
Z2NJRFDVDN6
2020-07-08 10:35:28
2020-07-14 08:24:35
5
21
49
7
VWN6ZZ99L3Q
2020-07-08 14:47:01
2020-07-14 08:24:35
5
17
37
34
GMN8T99TPMR
2020-07-07 18:20:02
2020-07-14 08:24:35
6
14
4
33
NTNS4MJ672W
2020-07-07 18:06:19
2020-07-14 08:24:35
6
14
18
16
V7NLG9GJ2B9
2020-07-09 12:52:35
2020-07-14 08:24:35
4
19
32
0
LGNFMNWML96
2020-07-09 11:37:13
2020-07-14 08:24:35
4
20
47
22
NMNP8S4HMDC
2020-07-08 14:34:21
2020-07-14 08:24:35
5
17
50
14
J6NT6YM6BYF
2020-07-09 13:08:53
2020-07-14 08:24:35
4
19
15
42
VBNHT8DPRD5
2020-07-08 15:11:35
2020-07-14 08:24:35
5
17
13
0
onsite095
2020-07-09 12:54:48
2020-07-14 08:24:35
4
19
29
47
HVN9P6WBWPD
2020-07-07 17:38:41
2020-07-14 08:24:35
6
14
45
54
KMNW7B2ZXV4
2020-07-08 13:13:04
2020-07-14 08:24:35
5
19
11
31
C:\Users\SGRUNE~1\AppData\Local\Temp\Engine_35384_2b536d2fbec3499190d8c4fa254e95e7_\Engine_2592_415bb33562014429b5e5b4794ff1628d_.yxdb
Single
プロファイル
時間の差/秒 = DateTimeDiff(DateTimeFormat([現在時刻],"%Y-%m-%d %H:%M:%S"),DateTimeFormat(...
C:\Users\SGRUNE~1\AppData\Local\Temp\Engine_35384_2b536d2fbec3499190d8c4fa254e95e7_\Engine_2592_188e6b22ccf54b7cbc24b49028829b2f_.yxdb
Single
プロファイル
Horizontal
challenge_ja_76_solution