How to convert Date Time stamp into Time

6 views (last 30 days)
Abhijit Dey
Abhijit Dey on 4 Apr 2019
Commented: Peter Perkins on 9 Apr 2019
I have a set of data sample in the attachment given. It consists of two columns, one is for Date and time and second one is of value.
When I read the file in matlab the 1st column appear as string.
Secondly I want conversion of that data time format into Time stamp (HH:MM:SS)
Please help me.
  2 Comments
madhan ravi
madhan ravi on 4 Apr 2019
Try using readtable() to read the file.
Peter Perkins
Peter Perkins on 9 Apr 2019
As madhan says:
1) Use readtable. You file has no column headers, so tell readtable to not try to read them
2) Your timestamps are in a somewhat funny format, they will come in as text. Convert them to datetimes, in the table, by specifying the input format
3) Use timeofday to convert to durations, again right in the table

Sign in to comment.

Answers (0)

Categories

Find more on Data Type Conversion in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!