Unable to load minutes correctly from CSV into in Power Query Pivot

0 votes

There are CSV files in a folder that include timestamps and parameter values.

The format of my timestamps is as follows:

DD/MM/YYYY HH:MM:SS

For example below:

09/01/2023 11:17:40

I load my query options in Excel 2019 and choose "English (United Kingdom)" for the regional settings. After that, I add my CSV file folder and build a pivot table using it.

The pivot table largely performs as intended and automatically changes the grouping of my TimeStamp column from Year to Seconds. At the Minute level, it appears to fall short, notably as shown below. The Minute looks to be 01, as can be seen from the image, but if you look at the timestamps below it, there should be minute groups for minutes 17, 18, and 19.


Instead, it appears that the Month value is passed to the Minutes field.

I think my date and time format is in line with the English locale (United Kingdom),

Below is a subset CSV for testing/replication:

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

enter image description here

Feb 3, 2023 in Others by Kithuzzz
 • 38,000 points • 380 views

1 answer to this question.

0 votes

Try this:

#"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]))

enter image description here

answered Feb 3, 2023 by narikkadan
 • 63,600 points

Related Questions In Others

0 votes
1 answer

Unable to download excel file from src/assets in development/qa/prod environment for angular application

Try this: this.HttpClient.get("./assets/sample.xlsx",{responseType: "blob"}).subscribe((res:any) => ...READ MORE

answered Nov 12, 2022 in Others by narikkadan
 • 63,600 points • 3,640 views
0 votes
1 answer

Stop power query from loading to excel sheet

You can just delete the worksheets created ...READ MORE

answered Dec 17, 2022 in Others by narikkadan
 • 63,600 points • 5,276 views
0 votes
1 answer

How to unmerge multiple cells and transpose each value into a new column in Pandas dataframe from excel file

Try this: df = pd.read_excel("Sample_File.xlsx", header=[0,1,2,3,4,5], index_col = ...READ MORE

answered Jan 8, 2023 in Others by narikkadan
 • 63,600 points • 2,534 views
0 votes
1 answer

How to get filtered value of an item as line chart which is absent from column chart in combined chart in Power BI?

By making a new measure that didn't ...READ MORE

answered Feb 14, 2023 in Others by Kithuzzz
 • 38,000 points • 797 views
0 votes
1 answer

Combing data from multiple workbooks into a single master workbook using power query

PowerQuery would scan the contents of all ...READ MORE

answered Apr 7, 2023 in Others by Kithuzzz
 • 38,000 points • 559 views
0 votes
0 answers

How to handle large http response data from observer in Angular application to avoid browser crash?

Suppose we have a angular application which ...READ MORE

Apr 19, 2019 in Others by Hemant Gajbe
 • 2,598 views
0 votes
0 answers

unable to connect to internet in edureka VM

i am unable to connect to internet ...READ MORE

Jun 7, 2019 in Others by Ashok
 • 120 points • 542 views
+1 vote
1 answer

In community edition I am unable to create tenant ,Getting this error"the filed client IP Address must be a string or array type with maximum length 64"

length is too high READ MORE

answered Jan 22, 2020 in Others by paul
 • 140 points • 1,119 views
0 votes
1 answer

How to build a custom column formula in Power query that will retrieve Image and load it to Excel to display that image from the specified column

Make sure ignore privacy is selected in ...READ MORE

answered Feb 5, 2023 in Others by narikkadan
 • 63,600 points • 1,198 views
0 votes
1 answer

Unable to import data in excel from another website using VB code

Replace : Set ieTable = ieDoc.all.Item("report-table") With: Set ieTable = ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
 • 63,600 points • 790 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.