Hi JBF,
Great tip! changing it to [HH]:MM:SS did do the trick.
Rdb
--
View this message in context:
http://nabble.documentfoundation.org/Negative-time-values-tp2888622p2892857.html
Sent from the Users mailing list archive at Nabble.com.
--
Unsubscribe instructions: E-mail to
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
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
Hi Rik,
On 02/05/11 13:48, rdb wrote:
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.
Than go back