https://community.jmp.com/t5/Discussions/format-dur%C3%A9e-date/m-p/632576#M83094 <P>Change the formats of other duration columns to Best</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1684325886117.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52844i1D59EC2569935549/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1684325886117.png" alt="jthi_0-1684325886117.png" /></span></P> <P>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?</P> Wed, 17 May 2023 12:21:00 GMT jthi 2023-05-17T12:21:00Z https://community.jmp.com/t5/Discussions/format-dur%C3%A9e-date/m-p/632540#M83093 <DIV>Bonjour à tous,</DIV><DIV>&nbsp;</DIV><DIV>Sur la base de données suivante j’ai un problème d’affichage des durées.</DIV><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hcarr01_0-1684321696089.png" style="width: 504px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52843i5F44F68B99454266/image-dimensions/504x33?v=v2" width="504" height="33" role="button" title="hcarr01_0-1684321696089.png" alt="hcarr01_0-1684321696089.png" /></span></P><P>La colonne «&nbsp;test&nbsp;» est la somme de toutes les durées en format «&nbsp;h&nbsp;: m : s&nbsp;», une fois que le compteur dépasse 24h il revient à zéro, d’où ici le résultat 14h faux mais positif (bon résultat 38h).</P><P>La colonne «&nbsp;test2&nbsp;» est la somme de toutes les durées en format «&nbsp;jour&nbsp;:h : min&nbsp;: s&nbsp;», on remarque toujours le même problème, la durée est négative.</P><P>&nbsp;</P><P>&nbsp;</P><P>Je ne comprends pas comment JMP peut sortir un résultat négatif et ensuite un résultat positif juste en modifiant le format de la colonne.</P> Sun, 11 Jun 2023 00:01:17 GMT https://community.jmp.com/t5/Discussions/format-dur%C3%A9e-date/m-p/632540#M83093 hcarr01 2023-06-11T00:01:17Z https://community.jmp.com/t5/Discussions/format-dur%C3%A9e-date/m-p/632576#M83094 <P>Change the formats of other duration columns to Best</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1684325886117.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52844i1D59EC2569935549/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1684325886117.png" alt="jthi_0-1684325886117.png" /></span></P> <P>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?</P> Wed, 17 May 2023 12:21:00 GMT https://community.jmp.com/t5/Discussions/format-dur%C3%A9e-date/m-p/632576#M83094 jthi 2023-05-17T12:21:00Z https://community.jmp.com/t5/Discussions/format-dur%C3%A9e-date/m-p/632615#M83097 <P>Is this result better?</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DUR.PNG" style="width: 709px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52845i731CD7BDA6598C89/image-size/large?v=v2&amp;px=999" role="button" title="DUR.PNG" alt="DUR.PNG" /></span></P> <P>&nbsp;</P> <P>If so, see the formatting choice and formula in the attached data table.</P> Wed, 17 May 2023 14:18:25 GMT https://community.jmp.com/t5/Discussions/format-dur%C3%A9e-date/m-p/632615#M83097 Mark_Bailey 2023-05-17T14:18:25Z