How do I convert time format from 12h am/pm to 24h in Power Query?

Copper Contributor

This is the current format:

Capture.JPG

This is the format I need:

16:32:10

17:15:49

etc.

I need to do this in Power Query.

Any help appreciated. Thanks!

 

2 Replies
Where does the data come from? What is the data type of that column in PQ?

If you have 24 hours time format in your locale, you may change that column on type Time, PQ shall recognize it correctly.