Notice
You are now leaving support.minitab.com.
Click Continue to proceed to:
To use this function, choose .
Extracts the date and time portion of a date/time value such as "1/6/06 10:23." This function is useful in macros and formulas.
WHEN(number_or_text)
For number_or_text enter a text string in a default date/time format such as "3/6/16 10:23", a column containing such values, or a numeric representation of a date/time value.
If you enter a numeric representation of a date/time value, Minitab returns the complete date/time, including the day, hour, minute, and second. If you store the result in a constant, the output is the numeric representation of the date/time value.
| Calculator expression | Result |
|---|---|
| WHEN(41804.5) | 6/14/2014 12:00:00 PM |
For example, a sales manager wants to identify orders taken on or before 1/24/16 at 2:00 PM. The manager enters the expression WHEN(C2) <= WHEN("1/24/16 2:00:00 PM") and stores the results in C3. Minitab returns a 1 for values less than or equal to the value and a 0 for values greater than the value.
| C2-D | C3 |
|---|---|
| Order | Before 2 pm? |
| 1/12/2016 8:15 AM | 1 |
| 1/24/2016 10:15 AM | 1 |
| 1/13/2016 2:45 PM | 1 |
| 1/10/2016 3:10 PM | 1 |
| 1/14/2016 9:30 AM | 1 |
| 1/4/2016 4:40 AM | 1 |
| 1/10/2016 2:10 PM | 1 |
| 1/24/2016 3:15 PM | 0 |
| 1/23/2016 7:45 AM | 1 |
| 1/12/2016 1:15 PM | 1 |
You are now leaving support.minitab.com.
Click Continue to proceed to: