LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JoeGill
 
Posts: n/a
Default The shortcut to enter time in excel should include seconds.

The shortcut to enter the current time in an Excel workbook should include
seconds. Currently, if you hit CTRL+: (SHIFT ;) the current time is
displayed in the appropriate cell as 1:14 PM b default. Formatting the time
to read h:mm:ss, it is displayed with the seconds as :00
 
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How do I get real time stock quotes to my excel worksheet? walter Excel Discussion (Misc queries) 1 January 8th 05 12:01 AM
Excel Files Won't Open From Shortcut ConfusedNHouston Excel Discussion (Misc queries) 5 December 31st 04 06:25 PM
Cancelling shortcut ctrl-click which opens "Research" in Excel 200 thebear Excel Discussion (Misc queries) 1 December 1st 04 08:55 PM
Is there a keyboard shortcut for centering data in Excel? Antartica Excel Discussion (Misc queries) 2 November 30th 04 05:30 PM


All times are GMT +1. The time now is 07:37 PM.

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

About Us

"It's about Microsoft Excel"