View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scotta0471 Scotta0471 is offline
external usenet poster
 
Posts: 1
Default needing a keystroke for the current date AND time

I know that CTRL + ; gives the current date, and I know that CTRL + SHIFT + :
gives the current time. Is there a keystroke that gives the current date AND
time? I'd like to enter a start time quickly in one column and then a
closing time in another and have it calculated in a third. The individuals
who will be filling out this spreadsheet need a very quick and dirty way to
do it. Thanks.