Thread: 24 hour time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default 24 hour time


Cells(a - 1, "I").Value = InputBox( _
"Enter MW Amount for period " & _
Format(Cells(a - 1, "N"),"mm/dd/yy hh:mm") & " to " & _
Format(Cells(a - 1, "O"),"mm/dd/yy hh:mm")

HTH
--
AP

PS: I turned Range into Cells, because it's more optimized

"srroduin" a écrit dans le message de
news: ...
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. :)