WksTimeFmtType Values
The WksTimeFmtType value is used by the worksheet when a time format is set with the SetDateTimeFmtType method or the TimeFmtType property. The Value is also used by the Numeric Label Property Syntax for the DateFormat option.
Time Formats
All rows below use the time 2:45:44.12 PM on September 7th, 1998 for the Example.
|
Enumeration |
Value |
Display |
Example |
Description |
|
wksTimeFmt_NONE |
0 |
(None) |
36045.615093981 |
Time not displayed |
|
wksTimeFmt_H_MM |
1 |
h:mm |
14:45 |
Hour in 0-23 (military time), two digit Minutes 00 to 60 |
|
wksTimeFmt_H_MM_AMPM |
2 |
h:mm AM/PM |
2:45 PM |
Hour in 0-12 (standard format), two digit Minutes 00 to 60, then a space and AM or PM |
|
wksTimeFmt_H_MM_SS |
3 |
h:mm:ss |
14:45:44 |
Hour in 0-23 (military time), two digit Minutes 00 to 60, two digit Seconds 00 to 60 |
|
wksTimeFmt_H_MM_SS_AMPM |
4 |
h:mm:ss AM/PM |
2:45:44 PM |
Hour in 0-12 (standard format), two digit Minutes 00 to 60 |
|
wksTimeFmt_MM_SS |
5 |
mm:ss |
45:44 |
Two digit Minutes 00 to 60, two digit Seconds 00 to 60 |
|
wksTimeFmt_MM_SS_0 |
6 |
mm:ss.0 |
45:44.1 |
Two digit Minutes 00 to 60, two digit Seconds 00 to 60, fractional seconds rounded to the nearest tenth of a second |
|
wksTimeFmt_TOTALHOURS_MM_SS |
7 |
[h]:mm:ss |
865094:45:44 |
Total hours (day value plus hour value), two digit Minutes 00 to 60, two digit Seconds 00 to 60. Example Explanation: Date value 865080 = September 7, 1998 Hour value = 14, added to 865080 = 865094 |
|
wksTimeFmt_H_MM_SS_FRACTION |
8 |
h:mm:ss.000 |
14:45:44.12 |
Hour in 0-23 (military time), two digit Minutes 00 to 60, two digit Seconds, 00 to 60, fractional seconds with full precision |
|
wksTimeFmt_HH_MM |
9 |
hh:mm |
14:45 |
Two digit Hour 00-23 (military time), two digit Minutes 00 to 60 |
|
wksTimeFmt_HH_MM_SS |
10 |
hh:mm:ss |
14:45:44 |
Two digit Hour 00-23 (military time), two digit Minutes 00 to 60, two digit Seconds 00 to 60 |
|
wksTimeFmt_MM_SS_FRACTION |
11 |
mm:ss.000 |
45:44.12 |
Two digit Minutes 00 to 60, two digit Seconds 00 to 60, fractional seconds with full precision |
|
wksTimeFmt_M_SS |
12 |
m:ss |
45:44 |
Single digit Minutes 0 to 60, two digit Seconds 00 to 60 |
|
wksTimeFmt_M_SS_0 |
13 |
m:ss.0 |
45:44.1 |
Single digit Minutes 0 to 60, two digit Seconds 00 to 60, fractional seconds rounded to the nearest tenth of a second |
|
wksTimeFmt_M_SS_FRACTION |
14 |
m:ss.000 |
45:44.12 |
Single digit Minutes 0 to 60, two digit Seconds 00 to 60, fractional seconds with full precision |