Why are the hour portions of my GMT times not being shown when I export data to Excel?

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.

Answer 1

[Brad]

For unknown reasons, I had to add the following 2 lines of code to solve this problem;

RangeObject = ActiveSheet.Range('CELL:CELL');
RangeObject.cells.EntireColumn.NumberFormat = 'hh:mm:ss.000');

I've never had to do this using previous versions of EXCEL. But for EXCEL 2010 it appears to solve the problem.

Answer 2

[Chad Greene]

It looks like exporting dates and times to Excel might require special treatment.

[Brad]

Definitely requires some kind of treatment. But I've found nothing definitive yet.