G Guest Jan 20, 2006 #1 How do I format time to hh:mm am/pm (hours and minutes with am or pm in lowercase)?
W Wayne Morgan Jan 20, 2006 #2 The statement Format(Time(),"hh:nn am/pm") does what you are asking. Minutes are "n", "m" is Months. Placing hh:nn am/pm in the Format property of a textbox will do the same thing.
The statement Format(Time(),"hh:nn am/pm") does what you are asking. Minutes are "n", "m" is Months. Placing hh:nn am/pm in the Format property of a textbox will do the same thing.
J John Vinson Jan 20, 2006 #3 How do I format time to hh:mm am/pm (hours and minutes with am or pm in lowercase)? Click to expand... m means Months, n means miNutes... Try hh:nn a/p John W. Vinson[MVP]
How do I format time to hh:mm am/pm (hours and minutes with am or pm in lowercase)? Click to expand... m means Months, n means miNutes... Try hh:nn a/p John W. Vinson[MVP]