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

조회 수: 4 (최근 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 CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by