cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
sanchezpeinado
Level III

Why time shows as HH:MM and thousands?

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?

 

sanchezpeinado_1-1700581844925.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Why time shows as HH:MM and thousands?

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

jthi_1-1700589300331.png

 

jthi_0-1700589258312.png

Note: this will break N and N Missing though, as they will be formatted as time so might be a good idea to hide those.

jthi_2-1700589347428.png

 

 

-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

Re: Why time shows as HH:MM and thousands?

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

jthi_1-1700589300331.png

 

jthi_0-1700589258312.png

Note: this will break N and N Missing though, as they will be formatted as time so might be a good idea to hide those.

jthi_2-1700589347428.png

 

 

-Jarmo

Recommended Articles