On 02/05/11 13:04, rdb wrote:
Hi,
Is there a straightforward way in Calc to calculate negative time values? By
default, this does not appear to be possible, e.g. 00:00:00 - 02:00:00 is
always 22:00:00, not -02:00:00.
rdb--
View this message in context:
http://nabble.documentfoundation.org/Negative-time-values-tp2888622p2888622.html
Sent from the Users mailing list archive at Nabble.com.
Hi rdb,
My system works as expected and as you described.
I had two cells. Formatted each as time format then entered the values
you specified. I created a formula Cell01-Cell02 or 00;00:00 - 02:00:00
and got the answer -02:00:00 not 22:00:00.
The only way I can reproduce your effect is to enter the following
formula in a field =TIME(0,0,0)-TIME(2,0,0). If I actually type
=00:00:00-02:00:00 I get -02:00:00, if I put the two TIME() functions in
separate fields I get -02:00:00.
I suppose for clarity it would be best to separate 'duration' from
'time-of-day' and treating them separately, depending on your needs.
Summary: Put you values in separate fields and use formulas to add and
subtract values.
--
Cheers Simon
Simon Cropper
Principal Consultant
Botanicus Australia Pty Ltd
PO Box 160, Sunshine, VIC
W: www.botanicusaustralia.com.au
--
Unsubscribe instructions: E-mail to users+h...@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