The very first time you enter this, it is likely you'll get an error because the formula is circular. You could, however, make the formula in column A a bit more complex, in this manner: This means that the time shown in the column A cell containing this formula will always be changing it won't be a true time stamp. If there is something there, then the NOW function is called, returning the current time of the recalculation. Thus, anytime the worksheet is recalculated, the contents of cell B2 are checked. Remember that the function always returns the current time. While this will enter a time into column A if the corresponding cell in column B contains something, it won't give satisfactory results because of how the NOW function works. If you want a more automatic approach, you might think that you could use a simple formula in column A, such as this: Provided the cell is formatted to show times in 24-hour format, you'll see the current time as you want it. The simplest way to go about this is to use Excel's built-in shortcut for entering the current time: press Shift+Ctrl+ (that's a semicolon).
In approaching this problem, let's assume that you want the time stamp to go into column A and you'll be entering your "who, what, why," and other info starting in column B. This way she can save time from checking the clock to write down the time. When the cell next to it is empty, she wants her time stamp cell to be blank. She would like to create a worksheet that she can type into and have the time stamp automatically populate as soon as she enters text into the cell next to it in that row. She also needs to document the time (in 24-hour format) that the call came in. When a call comes in over the radio, she needs to document who, what, why, etc. Donna needs to keep a log of activity that occurred throughout the day at her dispatch center.
0 kommentar(er)
