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

Hi

        I suggest you to use the format cell. How ? Like this:

1) Select the cells where you are going to use for write your hours,
include the cell where you are going to put de difference between hours.
2) Go to Menu-Format-Cell and select Time. There are some formats,
select format like this: "01:37:46 PM"
3) Write yours times in the cells that you had selected.
4) Make the subtraction.
5) Example:

        -Select range of cells A1 until C1.
        -Format Range: Menu-Format-Time.
        -Write or put in cell A1 the first time (The greatest)
        Example: 07:45:12 AM
        -Write or put in cell B2 the second time
        Example: 01:30:12 AM
        -Make the subtraction in cell C1: A1 - B1
        Result: 06:15:00 AM

        I hope this solve your problem,

Regards,

Jorge Rodríguez
__________________


El mar, 19-07-2011 a las 12:26 -0700, Rich Shepard escribió:
> On Tue, 19 Jul 2011, Andreas Säger wrote:
>
> > =X1*24 returns the time number in cell X1 in unit "Hours".
> > =X1*24*Y1 multiplies the hours with an hourly wage in Y1.
>
> Andreas,
>
>    It's not working for me here. Cell D3 contains '01:00:00 PM' and cell E3
> contains '07:00:00 PM'. In cell F3 I have '=(E3*24)-(D3*24)' and the display
> is 0.00. If cell F3 contains '=E3-D3' then F3 shows '06:00'. The display for
> 1-1/4 hours is '01:15' rather than 1.25. As soon as I put parentheses around
> the cells the resulting display is '0.00'. Strange.
>
> Rich

-- 
Atentamente,

Jorge Rodríguez


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