On Wednesday 30 August 2006 10:52 am, Bernard SOJKA wrote:
> HI,
>
> I've to produce some spreadsheet with hous and minuts and cells
> MUST contain numbers like -03:12,10 ( result of calculation :
> difference between 2 cells) Instead of that, I get 23:56:47,90 . It
> is the difference between 24:00:00,00 and that number.
>
> I offered a proposal based on groups of 2 cells but I was told it
> is not the answer to the question.... because everything must be on
> the same cell. It HAS to be a number.
>
> I glanced at all HOW TO and found no answer.
>
> Can somebody help me ?
It is all in how you format your cells. The cells where the
subtraction formula are located should have the user format of
[HH]:MM.
To do this, right click a cell you will be placing the
subtraction formula. Select Format Cell from the context menu. Under
the Numbers tab click Time as the Category. Clear the Format code box
and enter the format I gave you. Click the green arrow to the right
of the Format code box, and click OK.
The brackets: [] are what make this work.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
