I received a text (tab delim) file with times in it. I opened in Excel and need to fix the times. Some times are in h:mm and work correctly in Excel. Other are just :mm and Excel will not see the...
Hi. The right approach is to import the text file with Power Query. Opening the text file directly with excel will give a lot problems. There are lots of tutorials about PQ on YouTube.
