Change time format to Power BI format

[Joycelu819]

Hi guys,

I am wondering if I can convert 7pm to 19:00:00 in Power BI.

I have a column of time with same format, which is required to be converted.

Thanks

Joyce

[v-yalanwu-msft]

Hi, @Joycelu819 ;

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Joycelu819 ;

You could select date\time column then change the format to "dd/mm/yy hh:mm:ss". like below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Joycelu819 , Assume AM PM are last 2 digits

if(right([column], 2) = "PM", time(12+left([Column]), len([Column])-2,0,0), time(left([Column]), len([Column])-2,0,0))

[Joycelu819]

@amitchandak Thanks for your answer. I tried to type this in the query bar, but it did not work. Did I do in a right way?

Joyce