Thread
:
24 hour time
View Single Post
#
2
Posted to microsoft.public.excel.programming
Ardus Petus
external usenet poster
Posts: 718
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. :)
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus