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

[RafaelKnuth]

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!

[v-juanli-msft · Accepted solution]

Hi 

There is a simple way to do this.

You could convert time format in Modeling->Format.

Best Regards

Maggie

[Anonymous]

Maybe you are new to the forum but OP specifcally wrote "I need to do this in power query".

Your response was not complete to the fullest extent.

Q: What's the office telephone number? A: It's at 456 East Sycamore. [WRONG]

[joyce23]

How to do it in edit query window?