How to animate the change in a variable with respect to date and time in matlab?

I have an excel file with date, time and depth columns. I want to animate the change in the depth from the start of the date to the end along with time running in the display. The time is also showing in decimal number instead of the hh:mm:ss format. Can anyone please help me with this?

Answer 1

[Monisha Nalluru]

From my understanding, you want to display the time value in the axes instead of decimal values.

You can use datetime function to convert decimal values to date format and then animate the depth with time

As an example

dates = datetime(excelDates,'ConvertFrom','excel') % or 'excel1904'
% now animate time and depth

[Niraj Bal Tamang]

I tried but it didn't worked. The error that i got was:

'Input data must be one numeric matrix when converting from a different date/time representation.'

I have also uploaded the data file. Can you please let me know if the datetime works for this or not?

Thank you