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

  • Thread starter Thread starter Sheryl
  • Start date Start date
S

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?
 
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.
 
Back
Top