Forum Discussion
Change time format to Power BI format
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
amitchandak
Super User
Super UserJoycelu819 , 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))
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