632540_en-US

liliconcom

duration/date format

Hello everyone,

I have a problem displaying durations in the following database.

The "test" column is the sum of all durations in "h:m:s" format, once the counter exceeds 24h it returns to zero, hence here the result 14h is false but positive (correct result 38h).

The column "test2" is the sum of all durations in the format "day:h:min:s", we always notice the same problem, the duration is negative.

I don't understand how JMP can produce a negative result and then a positive result just by changing the column format.

Advanced Statistical Modeling Consumer and Market Research Data Blending and Cleanup Mass Customization Quality and Process Engineering Re: format durée/date

Change the formats of other duration columns to Best

you will see that some of them are already negative (some seem to be using Time format and some duration). No idea why, maybe wrong conversion has been used at some point?

Re: format durée/date

Is this result better?

 

 

If so, see the formatting choice and formula in the attached data table.