![]() |
|
#1
|
|||
|
|||
![]()
It sounds as if when the user enters the logon in A2, you want H2 to capture the time the entry was made.
This can be done be formula, but it can't be made to be static unless you use VBA. The formula in H2 copied down would be =IF(A2<>"",NOW(),"") but you have to place a time format on the cell on you will just get numbers. The NOW() function in the formula is Volatile means if you select anything on the spreadsheet the time will change...it's dynamic. You can test this by selecting F9 and you'll see the time change. So, bottom line, if you want to lock in the time when A2 is updated, you'll need VBA. Do you want to go this route? |
#2
|
|||
|
|||
![]()
@jeffreybrown
If you remember the worksheet you helped me with before. This pertains to that same worksheet. As people enter we need to track them coming in so I'm looking for a way to minimize what all needs entered so the time of day will have to be locked. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
CPSmith | Excel | 1 | 03-26-2016 02:48 AM |
![]() |
hydrogyny | Word | 4 | 02-09-2015 08:57 PM |
Time allotted minus time used with result in hour and minute | esther6086 | Excel | 2 | 04-29-2014 05:03 PM |
Time & Date Formulas in Graphs | Ady_E | Excel | 5 | 11-15-2012 05:29 AM |
IE Object: Run-time problem (the link is not clicked in run-time but not in step-in | tinfanide | Excel Programming | 1 | 03-04-2012 12:05 AM |