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?
Accepted Solutions
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
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.
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
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.