Brian Barker escribió:
> At 10:30 14/01/2009 +0100, Chema wrote:
>> I use OOcalc 3 and I don't know how make this operation with hours:
>> one cell have 1650:00:00
>> other cell (C1 for example )is =sum (a1:a5) with this result 168:45:00
>> If I write other cell with = 1650 - C1 I obtain 39431:45:00. Cell has
>> time format
>> If I write other cell with = 1650:00:00 - C1 I obtain Err:502.
>> What I do wrong?
>
> When you type something like 1650:00:00 into a cell, it is interpreted
> and shown as a time. But the cell does not really have in it what you
> see: it has the time expressed as a number of days and it is the cell
> formatting - as Time - that cause the display to appear as it does.
> Your problem is that without the colons, your 1650 is interpreted as
> days, not hours. And the format of three numbers separated by colons
> is not recognised as a time in a formula. You can see this by using
> the formula
> =68.75-C1
> instead, which will work. The 68.75 here is your 1650 hours expressed
> as a number of days.
>
> But that is messy. Better, if you want to put a fixed time into a
> formula, you can do this in two easy ways, either:
> =TIME(1650;0;0)-C1
> where the parameters are the separate numbers of hours, minutes, and
> seconds, or:
> =TIMEVALUE("1650:00:00")-C1
> where the single parameter is a text string in the same format in
> which you would enter it into a cell.
>
> I trust this helps.
>
> Brian Barker
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
Hi again.
I receive a message that say me that with version 2 my formula works but
not works on version 3...
Is this a bug?
Regards
Chema
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
