Issue with lengt time format

[sergio0592]

Hi all,

I'am facing an issue about formatting a lenght time. I have a difference (Var N / N-1 in the screenshot below) between two lenght. For positive variations, it works (see the first three rows). But in the case of a negative variation, i have ##### and the corresponding number is -0,000365416990416991.

I get the correct value if i multiply this number with Nb seconds in a day (86400).

Do you have an idea what goes wrong??

Thanks

[sergio0592]

No more success with space ' - ' 

[marcus_sommer]

You could try it with another white space chars: Whitespace character - Wikipedia maybe this one: Zero-width space - Wikipedia.

- Marcus

[sergio0592]

Don't works either with ASCII 32. At home i have Open Office and i don't meet the problem but i'am on a sample dummy app, not on my real app but on the same kind of data.