WksTimeFmtType Values
The WksTimeFmtType value is used by the worksheet when a time format is set with the SetDateTimeFmtType method or the TimeFmtType property.
Time Formats
All rows below use the time 2:45:44.12 PM for the Example.
|
Enumeration |
Value |
Display |
Example |
Description |
|
wksTimeFmt_NONE |
0 |
(None) |
|
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 |