How to convert table with datetime in numeric (seconds)

I want to convert a table ('Zeitt' 1000x1 table) with the format 'dd-mmm-yyyy HH:mm:ss.SSS' (ist that right?) like '15-Jul-2022 12:12:43.086' into a number (seconds that passed by since the first date)

I tried many differnt commands, but still got errors, f.e.:

Zeit = datetime(Zeitt, 'InputFormat', 'dd-mmm-yyyy HH:mm:ss.SSS');

or

Zeit=datenum(Zeitt,'dd-mmm-yy HH:mm:ss.SSS',2021);

or

Zeit=convertTo (Zeitt,'.net');

[Stephen23]

@Miriam: please save your data (table) in a mat file, and then upload it by clicking the paperclip button.

[Miriam]

The mat file is attached here now

Answer 1

[Abderrahim. B]

Hi!

Try this:

load Zeitt.mat
time_sec = seconds(Zeitt.Time - Zeitt.Time(1))

Hope this helps

[Miriam]

It works, thanks!