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. Best, Rik -- View this message in context: http://nabble.documentfoundation.org/Negative-time-values-tp2888622p2888746.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+help@libreoffice.org 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