F Frank Kabel Oct 3, 2004 #2 Hi not possible with VBA. See: http://www.cpearson.com/excel/DateTimeEntry.htm
R Ragdyer Oct 3, 2004 #3 Check out this web page of Chip Pearson's: http://www.cpearson.com/excel/DateTimeEntry.htm
D David McRitchie Oct 3, 2004 #4 Before we can provide a solution, it helps to know what the question is. ]What does it show instead, or are you saying you really do want that decimal point at the end. Format as h:mm hh:mm [h]:mm or [hh]:mm the last two are for totals so that hours don't overflow into days. I expect that you have a format like hh:mm AM/PM that shows AM or PM.
Before we can provide a solution, it helps to know what the question is. ]What does it show instead, or are you saying you really do want that decimal point at the end. Format as h:mm hh:mm [h]:mm or [hh]:mm the last two are for totals so that hours don't overflow into days. I expect that you have a format like hh:mm AM/PM that shows AM or PM.
D David McRitchie Oct 3, 2004 #5 oops, I picked up the period but missed that you didn't have a colon in you input, sorry about that. So make that 3 votes to see Chip's page.
oops, I picked up the period but missed that you didn't have a colon in you input, sorry about that. So make that 3 votes to see Chip's page.
