Excel XML Time format & arithmetic

[Dominik]

Hi all,

I have an Excel Xml file and I want to perform a Sum operation with time
format cells.

If I set [h]:mm format to the cells ¡, I can see the next right values:

8:25
8:30
25:25

42:20 (SUM)

When I save the file as Excel XML 2003, I have this:

<Styles>
<Style ss:ID="s64">
<NumberFormat ss:Format="[h]:mm"/>
</Style>
</Styles>

<Row ss:AutoFitHeight="0">
<Cell ss:Index="2" ss:StyleID="s64"><Data
ss:Type="DateTime">1899-12-31T08:25:00.000</Data></Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:Index="2" ss:StyleID="s64"><Data
ss:Type="DateTime">1899-12-31T08:30:00.000</Data></Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:Index="2" ss:StyleID="s64"><Data
ss:Type="DateTime">1900-01-01T01:25:00.000</Data></Cell>
</Row>

But when I open the file again, I see these values:

248:25
248:30
25:25

522:20 (SUM)

How can I format cells to see the right values again?


Thanks in advance,

Dominik.