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