Do you want the timestamp (22:57:13) to be split into separate rows or placed all in the same column?
Either way, a combination of xlsread and xlswrite, combined with some quick matrix modifications, will be all you'll need.
If you're not concerned about the datatypes in MATLAB (doesn't look like you are), you can pull the data in as a cell array without respect to format by specifying a third output argument to xlsread:
[~,~,rawData] = xlsread('my_file.xlsx',...)
After that, you just have to select the extent of the array you want to keep. If you don't want the first 5 rows by 14 columns of your excel data, set them to blank:
rawData(1:5,1:12) = {[]};
Finally, if you want to parse out the timestamps, use strsplit with the colon (:) as your delimiter.
for i = 1:size(rawData,1)
rawData{i,3} = strsplit(rawData{i,3},':')
end
Alternatively, if you just want to replace the colons with spaces, use regexprep:
for i = 1:size(rawData,1)
rawData{i,3} = regexprep(rawData{i,3},':',' ')
end
Once you've made all the changes you want, just write the data back to excel:
xlswrite('my_file.xlsx',rawData)
