Forum Discussion

Rafal Knuth's avatar
Rafal Knuth
Copper Contributor
May 10, 2018

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

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

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Where does the data come from? What is the data type of that column in PQ?

Resources