ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   displaying times in combo boxes (https://www.excelbanter.com/excel-programming/332146-displaying-times-combo-boxes.html)

LHaro

displaying times in combo boxes
 
Hi -

I am trying to determin the time difference between two combo boxes - the
first one being the start time & the second being the ending time. How can i
display the times in standard time format rather then military time? Any
help would be appreciated.

Thanks.

bhofsetz[_40_]

displaying times in combo boxes
 

Have you specified the number format for the combo box text?

combobox1.NumberFormat = "h:mm AM/PM

--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880
View this thread: http://www.excelforum.com/showthread.php?threadid=38017



All times are GMT +1. The time now is 06:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com