Hi again,

I don't think that I can really help you. Am I correct in assuming that
1899-12-31 is meant to represent Zero time? If so you could try 00:00:00?

Don't have any other suggestions.
--
Regards,

OssieMac


"Dmitriy Shapiro" wrote:

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.