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