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

Please help to plot the attached data.xlsx (time ) in excel to the required 24 hour format.

[KSSV]

Read here: https://de.mathworks.com/help/matlab/creating_plots/change-tick-marks-and-tick-labels-of-graph-1.html

Answer 1

[Shubham Rawat]

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!