# Automatic time entry question

#### E. Jones

##### Board Regular
Hello all,

What I need is a way for a cell to automatically insert the actual time information was entered into another cell, without erasing a previous time already calculated. In the example below, information was entered in B2 at 1:30 PM, so the time showed in A2. At 1:40 PM, information was entered in C3, so 1:40 PM populated in A3. At this point, nothing has been entered in any other cells, therefore, no time shows in any more cells in column A. But, once I do put something in either column B or C, I need the current time to populate in Column A without disturbing the times that are already entered in A2, A3, etc.

If this is possible, that you very much in advance.

 A B C 1 Time Info 1 Info 2 2 1:30 PM new information written here 3 1:40 PM new information written here 4 5

<tbody>
</tbody>

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### hajiali

##### Well-known Member
try in cell A1 =IF((OR(B1<>"", C1<>"")),NOW(),"") and drag the formula down to all the A columns you want, make sure you have time format for Column A other wise it will appear as decimal

#### E. Jones

##### Board Regular
Hajiali,

This formula works well except for the most critical aspect. I need any previous times that are recorded to stay saying the same thing, but when I input new information, ALL of the times change to the time of the last entry. How do I go about fixing this?

#### E. Jones

##### Board Regular
Hello all,

=IF((OR(B2<>"",C2<>"")), IF(A2="",NOW(),A2),"")

You will get an error message at first, but the fix is easy. Go into your options menu and select formulas, then ensure that the "enable iterative calculation" box is selected, and you will be good to go! Hope this helps someone.

Replies
8
Views
174
Replies
1
Views
173
Replies
4
Views
162
Replies
6
Views
387
Replies
3
Views
107

1,195,910
Messages
6,012,257
Members
441,687
Latest member
urimagic

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back