nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Turning date/time data into days for individual runs

BioMTT

Hello,

Trying to use a formula (or JSL if I need to) to get days for manufacturing runs. I think I need two If/ then statements to get the days to go from 0-12, given the run number/ batch ID and the date/time stamp right? I have tried a few formulas, and searched this forum (and google); however, I have not been able to get the correct output. Unfortunately my programing days are so long ago I can only write the most basic lines. I have JMP 18 and a few weeks to get this, so any ideas would be great! Also I attached a small sample of the date/time format I am attempting to put into days (so I can compare run data from different years, with days on the X axis alone).............Thanks MTT

Sample Dataset for Date Time to Days question.jmp

Accepted answers

jthi

Not sure how you wish to do it, but could you just add time of day to the days? You can create Time Of Day column using right click quick formula on your Date/Time column, then add that to Day column BUT remember to divide the time of day by In Hours(24) (or 60*60*
24) to turn it into "days".

All comments

jthi

I'm not exactly sure what you are trying to do. What "days" are you looking for? Can you provide some examples / expected result in your example dataset?

BioMTT

Hey thanks for the fast reply!! So trying to get to days for each run, but runs done in different years, so below is an example- does this make sense?

jthi

How should the days be calculated? First date of a Run is 0 and then add days after that? If that is the case, create a date column

Then use

(:Date - Col Min(:Date, :Run)) / In Days(1)

in separate formula

BioMTT

Ok that looks close- so I will try that now- and will that reset to 0 days for each run? Would I have to use another if/then to reset to day 0 for each batch? Again thanks for the quick response(s)!