https://community.jmp.com/t5/Discussions/Why-time-shows-as-HH-MM-and-thousands/m-p/701540#M88613 <P>I think you will have to modify the the format of summary statistics. Right click on the numeric part of Summary Statistics and select Format Column</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1700589300331.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/58995i245FB3CF551BB3A2/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1700589300331.png" alt="jthi_1-1700589300331.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1700589258312.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/58994i53B62DF7DC657425/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1700589258312.png" alt="jthi_0-1700589258312.png" /></span></P> <P><STRONG>Note:</STRONG> this will break N and N Missing though, as they will be formatted as time so might be a good idea to hide those.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_2-1700589347428.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/58996i570DF6AAE82E5E65/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_2-1700589347428.png" alt="jthi_2-1700589347428.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 21 Nov 2023 17:56:04 GMT jthi 2023-11-21T17:56:04Z https://community.jmp.com/t5/Discussions/Why-time-shows-as-HH-MM-and-thousands/m-p/701450#M88605 <P>I have multiple columns with times for a procedure. I divided it into 4 stages and created a formula for time expended in each stage. However, when I try to get the mean and SD, the time appears in thousands while the median and quartiles show in HH:MM, which is the format that I want. Does anyone know why that happened?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sanchezpeinado_1-1700581844925.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/58990i373B4FCF7D2A0508/image-size/medium?v=v2&amp;px=400" role="button" title="sanchezpeinado_1-1700581844925.png" alt="sanchezpeinado_1-1700581844925.png" /></span></P><P>&nbsp;</P> Tue, 21 Nov 2023 15:51:48 GMT https://community.jmp.com/t5/Discussions/Why-time-shows-as-HH-MM-and-thousands/m-p/701450#M88605 sanchezpeinado 2023-11-21T15:51:48Z https://community.jmp.com/t5/Discussions/Why-time-shows-as-HH-MM-and-thousands/m-p/701540#M88613 <P>I think you will have to modify the the format of summary statistics. Right click on the numeric part of Summary Statistics and select Format Column</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1700589300331.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/58995i245FB3CF551BB3A2/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1700589300331.png" alt="jthi_1-1700589300331.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1700589258312.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/58994i53B62DF7DC657425/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1700589258312.png" alt="jthi_0-1700589258312.png" /></span></P> <P><STRONG>Note:</STRONG> this will break N and N Missing though, as they will be formatted as time so might be a good idea to hide those.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_2-1700589347428.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/58996i570DF6AAE82E5E65/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_2-1700589347428.png" alt="jthi_2-1700589347428.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 21 Nov 2023 17:56:04 GMT https://community.jmp.com/t5/Discussions/Why-time-shows-as-HH-MM-and-thousands/m-p/701540#M88613 jthi 2023-11-21T17:56:04Z