Time | VBAReference

The time can be displayed in one of many formats using the letter "h" or "H" to denote hours, the letter "m" to denote minutes, the letter "s" to denote seconds and the letter "t" to denote the time marker. The lowercase "h" denotes the 12 hour clock and uppercase "H" denotes the 24 hour clock. The "m" must be lowercase to denote minutes as opposed to Months. The "s" for seconds and "t" for the time marker string must also be lowercase.

Value	Meaning	Example
h	Hours without leading zeros for single digit hours (12 hour clock).	1
hh	Hours with leading zeros for single digit hours (12 hour clock).	01
H	Hours without leading zeros for single digit hours (24 hour clock).	1
HH	Hours with leading zeros for single digit hours (24 hour clock).	01
m	Minutes without leading zeros for single digit minutes.	9
mm	Minutes with leading zeros for single digit minutes.	09
s	Seconds without leading zeros for single digit seconds.	5
ss	Seconds with leading zeros for single digit seconds.	05
t	One character time marker string. This will be the first letter of the values in the AM symbol or PM symbol boxes in Regional Options	A
tt	Multi-character time marker string. This will be values in the AM symbol or PM symbol boxes in Regional Options	AM