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

On Tue, 19 Jul 2011, Sigrid Carrera wrote:

> The box is the default when you open LibreOffice. If you want to start directly with writer, you 
> can:
> - start from a terminal with "swriter" (without the quotes)

Sigrid,

  I'll put this in the shell script rather than the default 'soffice' that
seemed to work (it did with OO.o).

> If you have them installed using the OS tools, then they should be
> available for use with LibO as well. I don't know, what you can try now.
> But maybe someone else has an idea.

  Yes, they should all be recognized, but they're not. That's why I ask.
Perhaps someone else can help (off-list will work, too).

> Yes, Calc has this ability. The time format should not matter. Can you
> check the format of your cells with the times? Or better, the cells, that
> will contain your results. The format code should look like this:
> [HH]:MM:SS The square brackets around the HH indicate, that you can get
> more than 24 hours in total. Subtracting the start time from the end time
> should be sufficient.

  When I change the format of the duration cell to time (hh:mm), I now get
the proper value; it was user error on my part.

  The follow up question is how do I multiply the value of this cell by an
hourly rate (cell format numeric) to calculate the amount owed? Calc gets
upset trying to multiply a time (say 06:00) by a currency (say $20.00) to
produce a total currency value of $120.00.

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