i have excel sheet with two column which are time and amplitude data.i want create a signal using this values with .mat,.wav,.au format.but i can't import Xl data to matlab. time value accuracy is changed. actually time values are in 12:49:45 [hh:mm:ss] format.I converted its to number format.But i get this data into matlab time value precision is change as 41528.534. How to increase the decimal value precision of value in matlab? How to create the signal with above formats.
time(number format) amplitude 41528.9924189815 -1.035 41528.9924768519 -0.254 41528.9925347222 -0.645 41528.9925925926 -1.016 41528.9926504630 -0.645 41528.9927083333 -0.547 41528.9927662037 -0.781 41528.9928240741 -0.957 41528.9928819444 -1.172 41528.9929398148 -1.074 41528.9929976852 0.352 41528.9930555556 1.016 41528.9931134259 -0.156 41528.9931712963 -0.703 41528.9932291667 -0.176 41528.9932870370 -0.723 41528.9933449074 -0.703 41528.9934027778 -0.313 41528.9934606481 -0.586 41528.9935185185 -0.938 41528.9935763889 -1.23 41528.9936342593 -0.762 41528.9936921296 -0.938 41528.9937500000 -1.289 41528.9938078704 -1.133 41528.9938657407 -0.957 41528.9939236111 -0.215 41528.9939814815 -0.586 41528.9940393519 -0.625 41528.9940972222 -0.41 41528.9941550926 0.645 41528.9942129630 -0.059 original Exel datatime amplitude12:49:45 -0.91812:49:50 -0.72312:49:55 -0.8412:50:00 -1.05512:50:05 -1.2512:50:10 -1.48412:50:15 -1.50412:50:20 -1.48412:50:25 -1.38712:50:30 -1.60212:50:35 -1.62112:50:40 -1.58212:50:45 -1.21112:50:50 -0.99612:50:55 -0.85912:51:00 -0.74212:51:05 -0.97712:51:10 -0.91812:51:15 -0.97712:51:20 -1.03512:51:25 -0.80112:51:30 -0.93812:51:35 -0.56612:51:40 -0.21512:51:45 -0.15612:51:50 -0.50812:51:55 -0.64512:52:00 -0.46912:52:05 -0.52712:52:10 -0.48812:52:15 -0.39112:52:20 -0.449
Best Answer