Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I add an hour to what the user types into the input box of the ("Enter
start time 24-hour clock")? Private Sub Hourly_Click() Dim rng As Range Set rng = ActiveSheet.Cells(Rows.count, "A").End(xlUp).Offset(1, 0) rng.Value = InputBox("Enter start date mm/dd/yyyy") rng.Offset(0, 1).Value = InputBox("Enter start time 24-hour clock") rng.Offset(0, 1).Font.Bold = True rng.Offset(0, 2).Value = InputBox("Enter stop date mm/dd/yyyy") rng.Offset(0, 3).Value = InputBox("Enter stop time 24-hour clock") rng.Offset(0, 4).Value = InputBox("Enter TSN to increase") rng.Offset(0, 5).Value = InputBox("Enter TSN to decrease") rng.Offset(0, 6).Value = InputBox("Enter MW Amount") Set rng = Nothing End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I subtract 1 hour from one cell and input it another? | Excel Worksheet Functions | |||
help adding up hour totals on a logbook | Excel Discussion (Misc queries) | |||
Adding time over a 24 hour period | Excel Discussion (Misc queries) | |||
Adding on a 24 hour clock basis | Excel Worksheet Functions | |||
Adding hundreds of hour of time | Excel Programming |