O Oliver Mar 26, 2004 #1 How do I format time to show 01:15 PM instead of 1:15 PM? I need to add 0 for hours 1 - 9. Thanks Oliver
How do I format time to show 01:15 PM instead of 1:15 PM? I need to add 0 for hours 1 - 9. Thanks Oliver
G Guest Mar 26, 2004 #3 I've tried that.I get times in my combo box in this format 1:00:00 AM 1:15:00 AM .. .. .. If I enter the input mask 09:00\ >LL;0;_ I get error msg "the value you entered isn't appropiate....." Thanks Oliver
I've tried that.I get times in my combo box in this format 1:00:00 AM 1:15:00 AM .. .. .. If I enter the input mask 09:00\ >LL;0;_ I get error msg "the value you entered isn't appropiate....." Thanks Oliver
E Elwin Mar 26, 2004 #4 =Format([MyDatefield],"hh:nn AM/PM") or just place the format in the format property of control hh:nn AM/PM
=Format([MyDatefield],"hh:nn AM/PM") or just place the format in the format property of control hh:nn AM/PM
