On 20/07/11 7:26 AM, Rich Shepard wrote:
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
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
--
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
