Need to update column "I" with current time as each employee checks into our excel check in sheet by entering 'here' in column "B". The time updates for every employee as each employee checks in rather then the column there name is in.
No formula needed. Highlight the cells that you want to put the time into. These are Raw data cells. You can use other cells to calculate their times. Right click and Format Cells, choose time and the appropriate format you would like.
To insert the time click in the cell you want and do a CTRL-SHIFT-;
That is Control - Shift - Semi-Colon. This will insert the Time. Leave out the Shift and you will insert the date.
OR-----
Press Ctrl-F11
Type:
Sub GetTime()
Dim vTime as Variant
vTime = Format)Now, "hh:mm:ss am/pm")
ActiveCell.Value = vTime
End Sub
Now add the forms toolbar to your excel.
Click Button to add a button.
Choose the GetTime() Macro
Rename and resize your button.
Click in the field you want to time to go to.
Click the Time button.
Read the fine manuals.
129 views
Usually answered in minutes!
The time of day each employee checks in? ie 8:00AM
On this post I assume that you have have a list of employees down a column such as "B" and in the "I" column their time for the day. What is the end result you are looking for?
×