Hi Wizz, thanks for the response....this opens up a whole new problem for me unfortunately.....

The thing that I am doing actually is combining an hour selection combobox, a minute selection combobox, and AM or PM from option buttons. After these 3 things are combined, the formatting ends up giving me a number like 0.33333 instead of say 7:00 AM. Is there any way to make this work without resorting to military time?