Put a formula into a column in excel for mac?

broken image

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.

broken image

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.