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

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

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