Hi , Thanks Alex for the suggestions but I still require further help. If i set the date to 1 January 1970, then i have this date in the formula field of excel. As long as i have a date object in the formula field i cant accumulate the duration in the excel cells. For 100 rows containing = 00.00,0 the outcome of this is 00.00,0. But if i sum 1000 rows in excel, it cant show me a result. If i calculate the sum of a column with 1000 rows then excel shows me on row 1001 (where i inserted the sum formula)only number signs (######).
-----Urspr�ngliche Nachricht----- Von: Alex Karshakevich [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 3. M�rz 2005 22:42 An: POI Users List Betreff: Re: problem with duration/time format in hssf Can you subtract away the date from your Calendar and be left with only the time component? Set the date to 1 January 1970. Alex. Alexander Groiss [P.A.S.T.] wrote: >Hi, > >excel provides duration/time formats like "mm:ss.0". >I use setDataFormat(HSSFDataFormat.getBuiltinFormat("mm:ss.0")) and >pass a calendar object to the setCellValue() method. >My problem now is that i have date informations then (like 27.11.2003 >00:00:01) and a "mm:ss.0" cell format in excel. >But for me its important to accumulate this duration datas. >Excel accumulates the whole date object. >Is it possible to pass it without the date component. > >Thanks for any help > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >Mailing List: http://jakarta.apache.org/site/mail2.html#poi >The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
