Hi, Le 02/05/2011 05:48, rdb a écrit : > Hi Simon, > > > > Thanks for your answer. > > > > Strange, I did exactly what you said and still have the same problem. All > fields are formatted as time HH:mm. Both with the standard formula > (=Cell1-Cell2) and using the TIME function (=TIME(0,0,0)-TIME(2,0,0) I get > 22:00:00 as my output.
Try to format the result cell as number not as time. Or choose this time format : [HH]:MM:SS (876613:37:46 in the time formats list) JBF -- Seuls des formats ouverts peuvent assurer la pérennité de vos documents. -- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
