Forum Discussion
Rafal Knuth
May 10, 2018Copper Contributor
How do I convert time format from 12h am/pm to 24h in Power Query?
This is the current format:
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
Sort By
If you have 24 hours time format in your locale, you may change that column on type Time, PQ shall recognize it correctly.
- JKPieterseSilver ContributorWhere does the data come from? What is the data type of that column in PQ?