Date/time data includes dates, such as Jan-1-2015 or 3/17/2015; times, such as 08:25:22 AM; or both, such as 3/17/2015 08:25:22 AM. Date/time data also includes elapsed time, such as 36:33:44 (elapsed hours, minutes, and seconds). Minitab stores dates and times as numbers, but displays them in whatever format you choose.
If you import date/time data into Minitab and determine that Minitab did not recognize it as date/time, you can change the data type to date/time. Choose Date, Time, or Elapsed time as the type., select the column, then select
Although date/time variables are displayed in date/time format in the worksheet, they are stored internally as numbers. The internal number includes an integer and a fraction. The integer represents the number of days since December 30, 1899; the fraction represents the fraction of the day completed. For example, the date/time value January 1, 1990 6:00 AM is stored internally as the number 32874.25 since there are 32874 days since December 30, 1899, and 6:00 AM is one quarter of a day.
December 30, 1899, 12 midnight is stored as 0. Dates and times before that date and time are negative numbers. For example, December 29, 1899 12 midnight is -1. Valid date/time values range from January 1, 1000 A.D. to December 31, 4000, with leap years determined by the proleptic Gregorian calendar.
To see the representative numeric values of a column of date/time data, choose Automatic numeric as the type., select the date/time column, then select
Calculations are always based on the internal number of the date/time variable. Some commands will display results in the Session and Graph windows as a number, and not as a formatted date/time value. Date/time values that are stored in constants are displayed as numbers.
Some commands will give you unexpected results when using date/time data. For example, consider an analysis of variance with a date/time variable as a factor. Two values in the date column, 1/1/99 and 1/1/99, may appear in the worksheet to be the same value because the column is formatted to display just the date portion. But the two values may have different time portions (for example, 10:30 PM and 8:20 AM) and, therefore, have different internal numbers. The analysis of variance will treat each value as a different factor level.
Minitab dialog boxes accept date/time data only in their default formats. These defaults can change depending on the regional settings of the Windows Control Panel.
However, you can adjust the range of two-digit years assigned to each century by customizing the calendar option in the regional settings of the Windows Control Panel. When you restart Minitab, it automatically updates its default date/time settings with the change.
Minitab always internally stores a complete date which includes a month, day, and year component. When you enter a date that does not include one of these components, Minitab stores a placeholder value for the missing component. For example, suppose the display format for a column is mm/yyyy. If you enter 12/2015, Minitab stores this values as December 1, 2015.