How to plot time in excel for 24 hours duration , and not as serial numbers

1 次查看（过去 30 天）
NN
NN 2020-11-21
回答： Shubham Rawat 2020-11-24
Please help to plot the attached data.xlsx (time ) in excel to the required 24 hour format.

请先登录，再回答此问题。

回答（1 个）

Shubham Rawat
Shubham Rawat 2020-11-24
Hi,
As a workaround, you can implement the following steps,
Step 1: You can import the data from the excel sheet to the MATLAB using “readmatrix”.
Step 2: You can convert the columns of dates into class datetime using “datatime”.
Step 3: Now you can make use of the datetime function and double in MATLAB in order to plot the data.
Hope this Helps!

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by