# Time Output in Excel, JMP, Minitab.

Six Sigma – iSixSigma Forums Old Forums General Time Output in Excel, JMP, Minitab.

Viewing 8 posts - 1 through 8 (of 8 total)
• Author
Posts
• #45127

Brit
Participant

I get a numeric response in data tables when I run a distribution for the mean, std deviation, etc when using time.
Does anyone know how to convert these into the actual time?
For example, I get 53355.29 as a mean time output.  I want that to be an “o’clock”.  Is it the number of seconds past 12 AM, meaning this would be:
(53355.29/3600) = 14.82 hours + 12:00 AM =
2:49:12 PM
Help!

0
#146391

Deep
Participant

If you got this out put (53355.29) from Excel and you are expecting a time instead, then you can get the corresponding time by changing the format of the cell. Right click the cell– Go to format cells– and change the formatting from Numbers to Time. If you want the time shown in a particular pattern, like only in hours or in minutes, you can do that by using the custom formatting. Please go through the Excel help file to get more informationDeep

0
#146392

Brit
Participant

I understand how to do that in excel – wanted to know the calculation to convert so when I get it in JMP and minitab that I can convert it and explain it to others.
Googled, but not sure what to google for.  Not sure what the time format is called when it looks like 34455.29

0
#146395

Deep
Participant

I dont know why you wan to do that in Minitab or Jmp where you can do the same with excel by changing the formatting. Excel use decimals to store time, 0 to 0.9999 (0=0:00 and 0.999 = 23:59). I dont think there is an easy formula to convert the decimal to corresponding time other then using Excels built in functions. You may want to ask this question in an Excel forum and if you find out the answer please post it here. Thank youDeep

0
#146396

Deep
Participant

I was re reading your post. Now I have a different interpretation of your original question. Can you re phrase your original question?

0
#146398

Brit
Participant

I have a time output:  53355.29
I want the time output in “o’clock” format (h:m:s).
I want to know the calculation to convert 53355.29 to h:m:s
I believe it is 53355.29/3600 seconds = 14.821 hrs + 12 AM = 2:49:15
Wanted confirmation or clarification on the calculation

0
#146409

Deep
Participant

Brit:You said I have a time output: 53355.29 How did you get this output? Is this in seconds, minutes?? Can you explain a little more about this output?I was in the impression that you did some kind of calculation in Excel and instead of giving time formatted output excel spits out the above number; In that case formatting the cells that I mentioned before will work. But it does not seem the case here. Like I said before if you can explain more about the output I or somebody else might able to helpDeep

0
#146480

Brit
Participant

The first time I saw it was in JMP.  I requested a distribution, giving average time of day for a hospital unit discharge.  The histogram showed time buckets in terms of normal time format.  The moments were in numerical form, such as the 53355.29.  I am assuming they’re seconds after 12 AM, but not entirely positive.  I have also seen this output in minitab. My mistake on excel – they do not have a function that will convert this number. I tried to find one so that I could backtrack the calculation. I may have missed it, but all I could find was Julian and Serial conversions, neither are right for this number.

0
Viewing 8 posts - 1 through 8 (of 8 total)

The forum ‘General’ is closed to new topics and replies.