Some date/time components in the following tables are not available in previous versions of Minitab. If you use these components in a custom date/time format and save the worksheet in an older version of Minitab, these components are converted to a different component, set to a default format, or ignored.
Component  How the date is displayed  Example 

m  Month as a number (1–12)  1, 2, and so on 
mm  Month as a twodigit number (01–12)  01, 02, and so on 
mmm  Month as a threeletter abbreviation  Jan, Feb, and so on 
mmmm  Month  January, February, and so on 
d  Day of the month (1–31)  1, 2, and so on 
dd  Day of the month as a twodigit number (01–31)  01, 02, and so on 
ddd  Day of the week as a threeletter abbreviation  Mon, Tue, and so on 
dddd  Day of the week  Monday, Tuesday, and so on 
yy  Year as a twodigit number  15, 16, and so on 
yyyy  Year as a fourdigit number  2015, 2016, and so on 
"Q" and the number of the quarter

Q1, Q2, Q3, Q4  
The number of the quarter and "Q"  1Q, 2Q, 3Q, 4Q  
Wkw  "Wk" and the week number
By default, Week 2 of each year begins the Sunday after January 1. The last week of the year ends on December 31. For most years, week 1 and week 53 have fewer than seven days. You can change the day that begins each week in the Windows Control Panel. If you want to display the year followed by the week, you must use this format or Wkww for the week (yyyyWkw, yyWkw, yyyyWkww, or yyWkww) 
Wk1, Wk2, and so on 
Wkww  "Wk" and a week as a twodigit number  Wk01, Wk02, and so on 
wWk  Week number and "Wk"  1Wk, 2Wk, and so on 
wwWk  Week as a twodigit number and "Wk"  01Wk, 02Wk, and so on 
Component  How the time is displayed  Example 

h  Hour (0–23)  7, 8, and so on 
hh  Hour as a twodigit number (00–23)  07, 08, and so on 
mm  Minute as a twodigit number (00–59)
Must be preceded by hour (for example, hh:mm) or followed by second (for example, mm:ss) 
08:01, 08:02 and so on 
ss  Second as a twodigit number (00–59)
Must be preceded by the minute (for example, mm:ss) 
08:01:01, 08:01:02, and so on 
.s  Tenths of a second (0–9)
Must be preceded by the minute and second (for example, mm:ss.s) 
08:01:01.1, 08:01:01.2, and so on 
.ss  Hundredths of a second (00–99)
Must be preceded by the minute and second (for example, mm:ss.ss) 
08:01:01.01, 08:01:01.02, and so on 
.sss  Thousandths of a second (000–999)
Must be preceded by the minute and second (for example, mm:ss.sss) 
08:01:01.001, 08:01:01.002, and so on 
AM/PM  The period of the day using 12hour time
Can be used only if hours are specified (for example, hh AM/PM) 
08:01 AM
08:01:01.02 PM 
A/P
am/pm a/p 
Additional indicators for AM/PM  08:01 A
08:01:01.02 pm 08:01:01.02 p 
Elapsed time measures the duration of an event. To denote elapsed time, enclose the largest time unit in square brackets. For example, the format [d].hh:mm:ss indicates elapsed time in days, hours, minutes, and seconds. If you assign that format to a column and enter 1.10:23, Minitab interprets the value as 1 day, 10 hours, and 23 minutes. If you assign that format to a column and enter 10:23, Minitab interprets the value as 0 days, 10 hours and 23 minutes.
Component  How the elapsed time is displayed  Example 

[d]  Days. When used with smaller components, elapsed days must be followed by a period (.).
NoteThis component is not supported in Excel. If you copy elapsed time data with the day component into Excel, the days are converted into hours. 
1 (1 day); 14.12 (14 days, 12 hours) 
[dd]  Days with a leading zero. When used with smaller components, elapsed days must be followed by a period (.).  01 (1 day); 14.12 (14 days, 12 hours) 
[h]  Hours as the largest unit of elapsed time. When used with smaller components, elapsed hours must be followed by a colon (:).  1 (1 hour); 1:20 (1 hour, 20 minutes) 
[hh]  Hours as the largest unit of elapsed time, with a leading zero. When used with smaller components, elapsed hours must be followed by a colon (:).  01 (1 hour); 01:20 (1 hour, 20 minutes) 
h  Hours (023). When used with smaller components, elapsed hours must be followed by a colon (:).  14.2:20 (14 days, 2 hours, 20 minutes) 
hh  Hours with a leading zero (0023). When used with smaller components, elapsed hours must be followed by a colon (:).  14.02:20 (14 days, 2 hours, 20 minutes) 
[m]  Minutes as the largest unit of elapsed time. When used with smaller components, elapsed minutes must be followed by a colon (:).  20:35 (20 minutes, 35 seconds) 
mm  Minutes (00–59) . When used with smaller components, elapsed minutes must be followed by a colon (:).
Can be used only if the hour (hh or h) is specified. 
14.12:20:35 (14 days, 12 hours, 20 minutes, 35 seconds) 
[s]  Seconds as the largest unit of elapsed time. When used with smaller components, elapsed seconds must be followed by a decimal symbol(.).  35.4 (35 seconds, 4 tenths of a second) 
ss  Seconds (00–59). When used with smaller components, elapsed seconds must be followed by a decimal symbol(.).
Can be used only if the minute (mm or [m]) is specified. 
14.12:20:35.4 (14 days, 12 hours, 20 minutes, 35 seconds, 4 tenths of a second) 
.s  Tenths of a second (0–9)
Can be used only if the second (ss) is specified. 
14.12:20:35.4 (14 days, 12 hours, 20 minutes, 35 seconds, 4 tenths of a second) 
.ss  Hundredths of a second (00–99)
Can be used only if the second (ss) is specified. 
14.12:20:35.44 (14 days, 12 hours, 20 minutes, 35 seconds, 44 hundredths of a second) 
.sss  Thousandths of a second (000–999)
Can be used only if the second (ss) is specified. 
14.12:20:35.444 (14 days, 12 hours, 20 minutes, 35 seconds, 444 thousandths of a second) 