What is the best way to write a duration type to an Excel file?

3 vues (au cours des 30 derniers jours)
Jason Nicholson
Jason Nicholson le 14 Jan 2016
Commenté : Jason Nicholson le 28 Déc 2020
I have an array of duration type. I want to write it to Excel and then use it as a time in excel. Is there a recommended way to get this effect?
d = duration([24;25],[0;10],[10;17]);
xlswrite('Example.xlsb', d);
If you write the d to Excel, the spreadsheet will not contain any version of the duration information in d.

Réponse acceptée

Lars Abrahamsson
Lars Abrahamsson le 23 Déc 2020
What about the other function to create Excel files from tables?
  1 commentaire
Jason Nicholson
Jason Nicholson le 28 Déc 2020
Yes, this works in 2020b. I am not sure it works in the 2016b or 2016a that I was working in at the time.
d = duration([24;25],[0;10],[10;17]);

Connectez-vous pour commenter.

Plus de réponses (1)

Walter Roberson
Walter Roberson le 14 Jan 2016
Modifié(e) : Walter Roberson le 23 Déc 2020
So write a serial date number which is the duration in days (and fraction of a day). You may wish to go in with ActiveX and apply a time format to the cell.


Community Treasure Hunt

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

Start Hunting!

Translated by