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; } } }

How do I copy only for value from the duration(day) and paste it as it is into new column.(but not time/date format)?

Mango1102

Since it is not a normal number, conditional formulas cannot be used.

Accepted answers

jthi

You can for example use Format with Format Pattern

Format(:142:12:05, "Format Pattern", "<Day>")

Do note that this will return a string not a number, so you might want to convert it to number using Num().

Day of Year might also work but I haven't tested if it will in all the situations

Day Of Year(:142:12:05) - 1

All comments

jthi

You should just be able to copy the value without any issues in JMP. For example value :142:12:05 will be pasted as 12312300 but you might have to change the format of column. You can also "convert" it to number (it basically already is already is, just formatted as duration) by using Num() function.

Show(:142:12:05, num(:142:12:05), :142:12:05 == 12312300);
// :142:12:05:00;
// Num(:142:12:05:00) = 12312300;
// :142:12:05:00 == 12312300 = 1;

Edit: Link regarding Date-Time Values from Scripting Guide Scripting Guide > Types of Data > Date-Time Functions and Formats > Date-Time Values

Mango1102

Thanks so much your quick response jthi.

But I want to use the conditional(If) formula by using the confirmed Duration value (Day) as it is.
However, as you said, each "Day" information has its own value, so it is difficult to use the "If" formula.
Is there any formula that i can change the confirmed value as a general number?

jthi

You can for example use Format with Format Pattern

Format(:142:12:05, "Format Pattern", "<Day>")

Do note that this will return a string not a number, so you might want to convert it to number using Num().

Day of Year might also work but I haven't tested if it will in all the situations

Day Of Year(:142:12:05) - 1

Mango1102

It's working. So appreciated.