| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get time entered automatically in A1 if B1 has text
I'm creating a log sheet that will have entries every few minutes in the
second cell or column B. I need the time to be automatically entered in A each time. Is this possible? I've tried several formulas with no luck. The closest formula that I can get is =IF(B1=1, "NOW()") however this will return an error. If this were to work then a 1 would have to be entered in B1. I tried using a wildcard with no luck also. Time taken from the computer clock is entered as =NOW() Please help if you can Thanks Tim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter text automatically based on current time | Excel Discussion (Misc queries) | |||
| integers entered automatically divide by 10 | New Users to Excel | |||
| Automatically entered decimal point. | Excel Worksheet Functions | |||
| How to automatically insert date when text entered in neighboring | Excel Discussion (Misc queries) | |||
| I need a time sheet template that verifies time entered against sy | Excel Discussion (Misc queries) | |||
Threaded Mode
