Convert text file to Excel file with dates in the correct format?

I'm trying to get my code (below) to convert FDATA.TXT (attached) to an Excel File (attached). Once in Excel, the dates all have "0:00" after them, and I want to get rid of these 0:00 times and just have the dates shown in Excel.

The text file is generated from a SD card Arduino coded in C++ (I think?). Thanks so much!

close all
clc
T = readtable('FDATA.TXT');       % read text file
T.Var3.Format = 'MM/dd/yyyy';   % I tried adjusting the date format
writetable(T,'Initial Table Data.xlsx')     % convert to Excel file

[Yazan]

I don't see any '0:00' in your excel sheet!

[Natalie Schmidt]

I've attached a screenshot- it's in the third column. Thanks so much!

[Walter Roberson]

Is it mandatory that the Excel output have 3 columns? It would make more sense to treat the second input column as a duration to be added to the third input column as a datetime, giving you a result that is a unified datatime entry that has date and time together as a single column.

Answer 1

[Simon Chan]

You may change it to a string format and write to an excel file.

clear; clc;
T=readtable('FDATA.TXT');
T.Var3=datestr(T.Var3,'mm/dd/yyyy');
writetable(T,'Initial Table Data.xlsx');

[Yazan]

Any success saving the data as datetime?

[Natalie Schmidt]

Thank you so much! While it worked for lines 1-95 in Excel, starting in line 96, the dates say "######" in Excel. (This is because the dates start repeating again in line 96 (starting again w/ 7/1/21- I don't know why). How can I fix that?

[Simon Chan]

Could you upload the file once again including line 96?