Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Increase the date/time in a excel table
Dear excel users,
I have a question. If have a worksheet with dates (my regional setting are e.g. 21-3-2006 15:00). I would like to be able to select a cell and then click on a button so I can increase the cell with for example 1 hour so I would get 21-3-2006 16:00. Any advise for me would be great because I am stuck. thnks and krgds, RMF |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Increase the date/time in a excel table
One way:
Put a Forms toolbar button on the sheet. Attach this macro: Public Sub AddHour_Click() If TypeOf Selection Is Range Then With ActiveCell If IsNumeric(ActiveCell.Value) Then _ .Value = .Value + 1 / 24 End With End If End Sub In article , RMF wrote: If have a worksheet with dates (my regional setting are e.g. 21-3-2006 15:00). I would like to be able to select a cell and then click on a button so I can increase the cell with for example 1 hour so I would get 21-3-2006 16:00. Any advise for me would be great because I am stuck. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting text format of time/date into Excel time/date for subtr | Excel Worksheet Functions | |||
Date/Time issue with Pivot Table | Excel Discussion (Misc queries) | |||
how to increase counter every time open excel | Excel Discussion (Misc queries) | |||
time between table in word and current date | Excel Programming | |||
I can increase to the number of columns in one excel table | Excel Programming |