[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