Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel XML Time format & arithmetic | Excel Programming | |||
binary arithmetic in excel | Excel Discussion (Misc queries) | |||
Excel 2007 Arithmetic | Excel Discussion (Misc queries) | |||
Is arithmetic on time data possible in Excel 2002? | Excel Discussion (Misc queries) | |||
Time arithmetic | Excel Programming |