View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dmitriy Shapiro[_2_] Dmitriy Shapiro[_2_] is offline
external usenet poster
 
Posts: 1
Default Excel 2007 vs. 2003 differencies for custom format [h]:mm:ss

Hi,

Thanks for reply.

Here is a fragment of my Xml Speadsheet:

<Styles
...
<Style ss:ID="s21"
<NumberFormat ss:Format="h:mm:ss"/
</Style
</Styles
<Worksheet ss:Name="Sheet1"
...
<Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1"
x:FullRows="1"
<Row
<Cell ss:StyleID="s21"<Data
ss:Type="DateTime"1899-12-31T01:09:45.000</Data</Cell
</Row
</Table
...
</Worksheet

When I open it in Excel 2007 I see "1:09:45"

When I try to plot the value it gets converted into "241:09:45"

Excel 2003 handles it with no problem.