how to increase the decimal places

Question

mahesh chathuranga 2013-9-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/88172-how-to-increase-the-decimal-places

评论： Ivan Alejandro Garcia Amaya 2020-4-1

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
9924189815  -1.035
9924768519  -0.254
9925347222  -0.645
9925925926  -1.016
9926504630  -0.645
9927083333  -0.547
9927662037  -0.781
9928240741  -0.957
9928819444  -1.172
9929398148  -1.074
9929976852  0.352
9930555556  1.016
9931134259  -0.156
9931712963  -0.703
9932291667  -0.176
9932870370  -0.723
9933449074  -0.703
9934027778  -0.313
9934606481  -0.586
9935185185  -0.938
9935763889  -1.23
9936342593  -0.762
9936921296  -0.938
9937500000  -1.289
9938078704  -1.133
9938657407  -0.957
9939236111  -0.215
9939814815  -0.586
9940393519  -0.625
9940972222  -0.41
9941550926  0.645
9942129630  -0.059
    original Exel data
time              amplitude
49:45  -0.918
49:50  -0.723
49:55  -0.84
50:00  -1.055
50:05  -1.25
50:10  -1.484
50:15  -1.504
50:20  -1.484
50:25  -1.387
50:30  -1.602
50:35  -1.621
50:40  -1.582
50:45  -1.211
50:50  -0.996
50:55  -0.859
51:00  -0.742
51:05  -0.977
51:10  -0.918
51:15  -0.977
51:20  -1.035
51:25  -0.801
51:30  -0.938
51:35  -0.566
51:40  -0.215
51:45  -0.156
51:50  -0.508
51:55  -0.645
52:00  -0.469
52:05  -0.527
52:10  -0.488
52:15  -0.391
52:20  -0.449