Power query duration not right

[calinorth]

When I import the duration for my data set it turns the 00 into 12 which is not the right duration .

the minutes and seconds are correct but for some reason power query converts the 00: into 12:. Any help would be greatly appreciated.

 

[arthurbr]

In the 24 hrs system, 12:00:42AM and 00:00:42 are the same ( 42 seconds past midnight). You can change the data to your locale with PQ if you prefer. Select the column - Change type - Using locale..