Importing Data from a text file

Should the second column be time in military format. In the original text file this cannot be determined from the data shown. You would have needed to advise us of such. Are the six digit format supposed to be hh:mm:ss format? If so that needs to be programmed. If I assumed correctly then I have formatted the second column as time in Power query before closing and loading to native excel. You can review the mcode in the file.