More than 23 hour format

Hi. How can I import a datetime with more than 23 hour format, like from 00:00:00 to 39:27:08 in my case. With HH:mm:ss it does not work when I pass 23:59:59 and I have not found another solution online yet. I got one row with 56531 cells. Thanks in advance!

Answer 1

[Walter Roberson]

use a duration object .

[Andreas Grøvan Aspaas]

How do I choose that object for all the cells when importing or do I have to import first by datetime or numbers or text and then choose duration object? I am quite new to matlab.

[Walter Roberson]

With new enough MATLAB readtable will detect time like fields that have no dates and will import them as duration objects .

Older MATLAB will import as cell array of character vectors in that case. For some of the most recent you release duration can parse those itself .

For older still you will need to parse the text into numeric columns and duration those .