This is what I have so far. I type the start date/time (04/24/06 13:00) and
stop date/time into an input box using a 24-hour clock. Later in the code it
brings up an input box from date1 to date2, etc. In this input box it
switches to using AM and PM. How do I get the input box to keep the 24 hour
clock?

Here's the part that shows Date1 (in column N) to Date2 (in column O):

Range("I" & a - 1).Value = InputBox("Enter MW Amount for period " &
Range("N" & a - 1) & " to " & Range("O" & a - 1))

Any help is appreciated. :)