LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 79
Default keyboard shortcut for dates and Time

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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
keyboard shortcut dicksadler Excel Discussion (Misc queries) 2 February 18th 09 11:24 PM
keyboard shortcut dicksadler Excel Discussion (Misc queries) 0 February 18th 09 11:00 PM
Keyboard shortcut GKW in GA Excel Discussion (Misc queries) 2 September 14th 08 11:35 PM
Keyboard shortcut: something new James Silverton[_2_] Excel Discussion (Misc queries) 3 September 23rd 07 01:15 PM
Keyboard Shortcut ArthurJ Excel Discussion (Misc queries) 3 January 12th 06 06:00 AM


All times are GMT +1. The time now is 06:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"