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

4 views (last 30 days)
Please help to plot the attached data.xlsx (time ) in excel to the required 24 hour format.

Answers (1)

Shubham Rawat
Shubham Rawat on 24 Nov 2020
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!

Community Treasure Hunt

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

Start Hunting!