How do I use NOW so that each cell displays a different time?

[Sheryl]

I have to keep track of the time and date that trucks hauling commodities
into our business. I would like to use the NOW function, but each time I do
all of the cells in that column change to the new time. What can I do and
can I create a Macro for this?

 

[Ragdyer]

How about some keyboard shortcuts using the colon/semi-colon key?

<Ctrl> < ; >
Then <Space>, then:
<Ctrl> <Shift> < : >

Gives you date and time in same cell.

 

[Sheryl]

Thanks so much! I knew I was probably making it harder than it was.