Re: [libreoffice-users] Negative time values

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+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