Thread: Time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Time

Not sure about clicking, but if you select a cell then do CTRL-SHIFT-
colon this will fix the time in that cell.

CTRL-semicolon will fix the date.

Hope this helps.

Pete

On Sep 11, 5:28 pm, jacksonsgurl
wrote:
How do you get a cell ixed to where you can click on it and the current time
automatically comes up and does not continue to follow the time clock after
you have selected the cell and clicked off of it? I am trying to make a
dispatch sheet for when my rescue squad has a call at a fair that we provide
support for. Any help anyone can give me would be great.