Excel XML Time format & arithmetic
 

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.