Create an arbitrary set of date/time values

Calc > Make Patterned Data > Arbitrary Set of Date/Time Values

Complete the following steps to fill a column with a pattern of date/time values that are not equally spaced, such as January June July.

  1. In Store patterned data in, enter a column number (for example, C1) or a column name. If the name contains spaces, enclose the name in single quotation marks.
  2. In Date/time values (eg, 8/26/96 "8/26/96 19:58"), enter the sequence of date/time values in the pattern, separated by spaces. The format must be one that Minitab recognizes. For more information, go to Date/time formats that Minitab recognizes. If the date/time value contains spaces, enclose the value in double quotation marks.
  3. Enter the repeat information for the pattern.
    1. In Number of times to list each value, enter the number of consecutive times to list each value in the sequence.
    2. In Number of times to list the sequence, enter the number of times to repeat the entire sequence.

For example, these settings create the following column of data.

  • Date/time values (eg, 8/26/96 "8/26/96 19:58"): "5 Jan" "10 Jan" "12 Jan"
  • Number of times to list each value: 2
  • Number of times to list the sequence: 3
C1-D
Numbers
5 Jan
5 Jan
10 Jan
10 Jan
12 Jan
12 Jan
5 Jan
5 Jan
10 Jan
10 Jan
12 Jan
12 Jan
5 Jan
5 Jan
10 Jan
10 Jan
12 Jan
12 Jan