excel 无法将“分钟”从CSV正确加载到Power Query / Pivot中

wlp8pajw  于 2023-02-05  发布在  其他
关注(0)|答案(1)|浏览(138)

我有一个包含时间戳和参数值的CSV文件的文件夹。
我的时间戳格式如下:

DD/MM/YYYY HH:MM:SS

举例如下:

09/01/2023 11:17:40

在Excel 2019中,我首先加载我的查询选项,并选择区域设置为“英语(英国)”。之后,我加载CSV文件的文件夹,并基于它创建一个透视表。
在大多数情况下,透视表按预期工作,并自动将TimeStamp列转换为从Year到Seconds的子组。但是,在Minute级别,它似乎失败了,具体如下所示。从图片中可以明显看出,Minute显示为01,但查看它下面的时间戳,应该有分钟组171819...
相反,似乎Minutes字段获得了Month的值。
我相信我的日期时间结构与英语(英国)的区域设置匹配,但有什么原因导致它不工作。有什么建议吗?
以下是用于测试/复制的CSV子集:

TimeStamp,BattTempMain,BatteryTotalChargeHV,BatteryTotalDischargeHV,BatteryVoltageHV,DistanceAccuracy,DistanceTotal,DistanceTrip,DistanceValid,EVSpeed,Fence1,Fence2,Fence3,Fence4,FenceCombined,FenceValid,IndoorTemp,Latitude,Longitude,Odometer,OutdoorTemp,Speed,SpeedAccuracy,SpeedValid,StateOfChargeBMS,GeofenceLocation,GeofenceStatus,Device,Meta
09/01/2023 11:17:40,18.0,500320.5802161523,505.7552105152147,377.0,,,,,0.0,,,,,,,18.6,,,1197.0,18.0,,,,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:17:45,18.0,500320.5799831355,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.6,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:17:50,18.0,500320.57986662706,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.6,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:17:55,18.0,500320.57963361026,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.6,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:18:00,18.0,500320.57951710187,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:18:05,18.0,500320.579284085,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:18:10,18.0,500320.5791675766,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:18:15,18.0,500320.5789345598,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:18:20,18.0,500320.5788180514,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:18:25,18.0,500320.5785850345,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:18:30,18.0,500320.57846852613,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:18:35,18.0,500320.57823550934,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:18:40,18.0,500320.57823550934,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:18:45,18.0,500320.57823550934,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:18:50,18.0,500320.57776947564,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:18:55,18.0,500320.57753645885,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:19:00,18.0,500320.57741995045,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:19:05,18.0,500320.5771869336,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:19:10,18.0,500320.5770704252,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:19:15,18.0,500320.57695391675,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:19:20,18.0,500320.57672089996,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:19:25,18.0,500320.57660439156,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:19:30,18.0,500320.5764878831,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:19:35,18.0,500320.5762548663,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:19:40,18.0,500320.5761383579,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:19:45,18.0,500320.57602184947,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:19:50,18.0,500320.5759053411,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:19:55,18.0,500320.5757888327,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:20:00,18.0,500320.5755558158,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:20:05,18.0,500320.57543930743,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:20:10,18.0,500320.57532279904,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:20:15,18.0,500320.5752062906,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:20:20,18.0,500320.5750897822,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:20:25,18.0,500320.5749732738,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:20:30,18.0,500320.57485676534,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:20:35,18.0,500320.57474025694,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:20:40,18.0,500320.57450724015,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:20:45,18.0,500320.5743907317,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:20:50,18.0,500320.5742742233,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:20:55,18.0,500320.5741577149,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:21:00,18.0,500320.5740412065,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:21:05,18.0,500320.57392469805,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:21:10,18.0,500320.57380818966,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:21:15,18.0,500320.57369168126,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,18.8,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:21:20,18.0,500320.5735751728,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:21:25,18.0,500320.5734586644,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:21:30,18.0,500320.573342156,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:21:35,18.0,500320.57310913916,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:21:40,18.0,500320.57299263077,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:21:45,18.0,500320.5728761224,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:21:50,18.0,500320.5727596139,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:21:55,18.0,500320.5726431055,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:22:00,18.0,500320.5725265971,505.7552105152147,377.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:22:05,18.0,500320.57241008873,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:22:10,18.0,500320.5722935803,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:22:15,18.0,500320.5721770719,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:22:20,18.0,500320.5720605635,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:22:25,18.0,500320.5719440551,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:22:30,18.0,500320.57182754664,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:22:35,18.0,500320.57171103824,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:22:40,18.0,500320.57159452984,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:22:45,18.0,500320.5714780214,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:22:50,18.0,500320.5712450046,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:22:55,18.0,500320.57089547935,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:23:00,18.0,500320.5704294457,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:23:05,18.0,500320.57007992046,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:23:10,18.0,500320.5696138868,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:23:15,18.0,500320.5691478532,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:23:20,18.0,500320.56879832793,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:23:25,18.0,500320.5683322943,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:23:30,18.0,500320.56786626065,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:23:35,18.0,500320.567400227,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:23:40,18.0,500320.56705070176,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:23:45,18.0,500320.5665846681,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:23:50,18.0,500320.5662351429,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:23:55,18.0,500320.56588561763,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:24:00,18.0,500320.5655360924,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:24:05,18.0,500320.56518656714,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:24:10,18.0,500320.56495355035,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:24:15,18.0,500320.5647205335,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:24:20,18.0,500320.5644875167,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:24:25,18.0,500320.56425449986,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:24:30,18.0,500320.56402148306,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:24:35,18.0,500320.5637884662,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:24:40,18.0,500320.5635554494,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:24:45,18.0,500320.5633224326,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:24:50,18.0,500320.5630894157,505.7552105152147,376.75,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:24:55,18.0,500320.56285639893,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:25:00,18.0,500320.5626233821,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:25:05,18.0,500320.5623903653,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:25:10,18.0,500320.56215734844,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:25:15,18.0,500320.5616913148,505.7552105152147,376.25,0.0,0.0,0.0,1.0,2.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,17.5,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:25:20,18.0,500320.56134178955,505.7552105152147,376.5,0.0,0.0,0.0,1.0,2.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.15350500000001,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq
09/01/2023 11:25:25,18.0,500320.56134178955,505.7552105152147,376.5,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,56.153505,10.177122,1197.0,18.0,0.0,0.0,0.0,73.6,None,0,1F4F8F26,SkodaEnyaq

tv6aics1

tv6aics11#

在查询中使用什么来提取小时、分钟和日期?

#"Added Custom" = Table.AddColumn(#"PriorStepNameHere", "Hour", each Time.Hour([TimeStamp])),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "Minute", each Time.Minute([TimeStamp])),
#"Added Custom2" = Table.AddColumn(#"Added Custom1", "Date", each Date.From([TimeStamp]))

相关问题