Why are the hour portions of my GMT times not being shown when I export data to Excel?
3 ビュー (過去 30 日間)
古いコメントを表示
I'm attempting to export some GMT time tagged data to Excel, that looks like this;
21:48:52.03 78532.0390000000 0
21:48:52.80 78532.8050000000 0
21:48:53.55 78533.5550000000 1
But when I export it to Excel, the result is this;
48:52.03 78532.0390000000 0
48:52.80 78532.8050000000 0
48:53.55 78533.5550000000 1
I'm attempting to format column E's number format with the following:
Activesheet.Columns.Item('E').NumberFormat='hh:mm:ss.000';
I'm using MATLAB 2015A and Excel 2010.
In looking at the on-line documentation, this should work - and does with older versions of MATLAB (2010a) and Excel (2003).
I've tried different number format combinations. None of which work and I get the exact result (above) every time.
Am I missing something subtle or just implementing this incorrectly?
Thank you.
0 件のコメント
採用された回答
その他の回答 (1 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!