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.
|