| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - clock in buttons problem
Assuming the "boxes" you have for time entries are cells:
Sub BookInClick() If Hour(Now) < 12 Then Range("BookInAM").Value = Now Else Range("BookInPM").Value = Now End If End Sub -- Jim Rech Excel MVP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Custom toolbar problem saving new buttons | Excel Discussion (Misc queries) | |||
| Incremental time values based upon clock in and clock out times | Excel Discussion (Misc queries) | |||
| How do I calculate time in excel (clock in and clock out | Excel Discussion (Misc queries) | |||
| Change EXCEL Clock to Standard Clock or Military Time | Excel Worksheet Functions | |||
| Start Clock/Stop Clock | Excel Discussion (Misc queries) | |||
Threaded Mode
