Page tree
Skip to end of metadata
Go to start of metadata

Description

NumberFormat values for Time data types

C#
vb.net

Values

Name

Description

ElapsedTimeInHours

[h]:mm:ss;@ (For example, 846312:00:00. For elapsed time Microsoft uses the start date of January 1, 1900.)

ElapsedTimeInMinutes

[mm]:ss;@ (For example, 50778720:00. For elapsed time Microsoft uses the start date of January 1, 1900.)

ElapsedTimeInSeconds

[ss];@ (For example, 3046723200. For elapsed time Microsoft uses the start date of January 1, 1900.)

HourMinute12

h:mm AM/PM;@ (For example, 12:00 AM.)

HourMinute24

h:mm;@ (For example, 0:00.)

HourMinuteSecond12

h:mm:ss AM/PM;@ (For example, 12:00:00 AM.)

HourMinuteSecond24

h:mm:ss;@ (For example, 0:00:00.)

MinuteSecondTenths

mm:ss.0;@ (For example, 00:00.0.)

  • No labels