RE: [libreoffice-users] Re: New User: Three Questions

It seems that OpenOffice.org and LibreOffice Calc will infer the type of a cell from the type of 
the formula result if no other type information is provided.  As far as I know, that is how results 
like 01:15 instead of 01.25 show up when the formula produces a date-time type of value.  If you 
want something different, it is necessary to over-ride the type by specifying the format you want.

 - Dennis

-----Original Message-----
From: Andreas Säger [mailto:villeroy@t-online.de] 
Sent: Tuesday, July 19, 2011 16:59
To: users@global.libreoffice.org
Subject: [libreoffice-users] Re: New User: Three Questions

Am 19.07.2011 22:45, Rich Shepard wrote:
> On Wed, 20 Jul 2011, Steve Edmonds wrote:
>
> > I have it working correct on LO3.4.1. Started from scratch (new sheet) in
> > A2. 1:00 tab 7:00 tab 12.5 tab =(B2-A2)*24*C2 and it all works ok.
>
> Steve,
>
> It works properly here, too, with the proper cell format. Somehow the two
> problem columns became typed as time rather than as number. When I figured
> that out and changed the cell formats the display corrected.
>
> The incorrect formatting might have been carried over from an existing
> column when I added a couple of interior new columns.
>
> Thanks,
>
> Rich

Again, the number format has absolutely no influence on the formula 
result. Never ever. Stop thinking in formatting attributes. They are 
meaningless. It's all about numeric cell values.


=(A1-B1)*24 is the same as (A1-B1)/TIME(1;0;0). Both convert days to 
hours. If the results happen to look different because you did not 
format the cell explicitly, this is a merely cosmetic effect.

=TIME(1;0;0)=1/24 returns TRUE because both expressions are perfectly 
equivalent.
=TIME(1;2;3) is just another way to calculate =1/24 + 2/1440 + 3/86400 
which is 1/24 of a day + 2/1440 of a day + 3/86400 of a day.
In other words: 1 hour + 2 minutes + 3 seconds

You can format the result of =PI() in thousands of different dates, 
times, currencies, percents with decimal commas and with decimal points 
without ever changing the value of Pi.


-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted