Forum Discussion
Formatting time
I am doing a time study and have some date time data that was given to me in a format where the time does not have a colon in it so formatting the cells is not working. Is there a way to easi...
If you load the data into Power Query and type a few example outputs, PQ will generate and apply the edits to the entire data field for you. I had to set a US locale in order to convert from US to rest of world date formatting.