Hello,
I just started working on Business Analytics Week - June 2021, from the learning summit series [ https://portal.enterprisedna.co/courses/305966/lectures/33172977]
The time format in the excel sheet is in 24 hrs format, however, when I am bringing it in the power query editor, it’s picking it up in a 12 hr format. I updated the column type to “Time”, but that isn’t changing the format. - Any advice on how can I get the 24 hr format? - within the power itself?
this is actually handled once you have loaded your data back to the Power Bi Desktop
remember - you are simply changing the appearance of the time, PowerBi (and Excel) both record time values as a decimal amount, to the programs it doesn’t matter what you make it look like as long as the format is a valid time.
Select the column you want to change, then select the “Column Tools” menu from the Ribbon in the Data Tab (or if you are in the Model tab, it is under the Properties area)
in Data tab:
in Model tab:
Got you! 
Thanks.
yes - It did automatically default to a 24 hr. format. once data was loaded
Cheers!
