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]
