Calculate difference between two times when I export text file to excel

1 回表示 (過去 30 日間)
Nicolas Rodriguez
Nicolas Rodriguez 2016 年 1 月 7 日
コメント済み: Adithya Addanki 2016 年 1 月 12 日
Hi, I am working on a time stamp program in matlab and I want to calculate the difference in times that I have registered with my program once I open the file in excel. Every time I try to subtract both times I get a #value! error in excel. Any help will be really appreciated.
Thank you
  2 件のコメント
Walter Roberson
Walter Roberson 2016 年 1 月 7 日
How are you writing the time stamps to excel? Are you writing them as strings, or as MATLAB datenum, or as MATLAB datetime objects, or are you converting datenum or datetime objects to excel numeric dates, or are you using writetable() of a table that contains datetime objects?
Adithya Addanki
Adithya Addanki 2016 年 1 月 12 日
Hi Nicolas,
As Walter mentioned, please verify the data type of the variables.
If it does not resolve the issue, please send us the workflow you follow and a sample code to help us reproduce the issue.
Thank you,
Adithya

サインインしてコメントする。

回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by