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:[email protected]] Sent: Tuesday, July 19, 2011 16:59 To: [email protected] 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 [email protected] In case of problems unsubscribing, write to [email protected] 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 [email protected] In case of problems unsubscribing, write to [email protected] 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
