Time in Combo Boxes


Posted by lenze on February 04, 2002 1:39 PM

I have a user form with combo boxes where a user can select times in 30 min. increments. I have used the code ComboBox1.Value=Format(ComboBox1, "h:mm") to format the display as time (ie. 9:00,11:30,2:00, etc.)
This works fine for all times except 12:00 noon. It displays as 0:05. Any ideas??

Thanks



Posted by John on February 04, 2002 1:52 PM

Try entering noon as 12:00:01.