Bernard SOJKA wrote:
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.
Use a number format with brackets, like "[MM]:SS,00".
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
