How do I Make A Plot Using System Time Values?

Hi there,

I'm having trouble figuring out something that I'm sure is really simple. I'm logging the output of a sensor, but the software generates timestamps using the system clock. I have tried using the import feature, to no success. I have attached the included log file in Excel format which I'm sure will clarify things a little bit.

Thanks.

Answer 1

[Gareth Thomas]

Maybe this will help you:

mydata = readtable('sensor_log.xls');
mydata.Time=datetime(mydata.Time,'ConvertFrom','datenum','Format','HH:mm:ss')

Please note that I am using R2015a.

If you are using earlier versions you might want to use datestr.

Answer 2

[Walter Roberson]

http://www.mathworks.com/matlabcentral/answers/254-converting-excel-serial-number-of-time-to-hh-mm-ss-format

http://www.mathworks.com/help/finance/x2mdate.html (Note: Financial Toolbox)