View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
rexmann rexmann is offline
external usenet poster
 
Posts: 79
Default keyboard shortcut for dates and Time

Apologies - forgot to say using Excel 2007

"rexmann" wrote:

Hi All

I know the keyboard short cut for date (Ctrl ;) and for time (ctrl shift ;)

Is there a short cut to enter date and time together

Equally is there a shortcut to enter the time in hh, mins and seconds
(reading from the computers clock)? when I use ctrl shift and ; it just does
hh and mm (even if set to hh mm and seconds

Any help greatly appreciated

Cheers Rexmann