Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-04-2013, 09:29 AM
jbwenu jbwenu is offline Current time keyboard shortcut Windows XP Current time keyboard shortcut Office 2007
Novice
Current time keyboard shortcut
 
Join Date: Feb 2013
Posts: 2
jbwenu is on a distinguished road
Default Current time keyboard shortcut

In Excel 2007, how can I get my keyboard shortcut for entering the current time to display seconds, too (00:00:00)?
Reply With Quote
  #2  
Old 02-05-2013, 01:00 AM
Kevin@Radstock Kevin@Radstock is offline Current time keyboard shortcut Windows 7 32bit Current time keyboard shortcut Office 2010 32bit
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

Hi jbwenu

How about if you pre-format the cells, custom: hh:mm:ss or using a format under the time category.

Kevin
Reply With Quote
  #3  
Old 02-05-2013, 06:56 AM
jbwenu jbwenu is offline Current time keyboard shortcut Windows XP Current time keyboard shortcut Office 2007
Novice
Current time keyboard shortcut
 
Join Date: Feb 2013
Posts: 2
jbwenu is on a distinguished road
Default

Thanks, but I can get the cell to display seconds without a problem, but I have to enter the seconds manually. Ctrl+Shift+semi-colon enters the current time, but only in hours:minutes. I am trying to get a keyboard shortcut to include seconds when it enters the current time (hours:minutes:seconds).
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Current time keyboard shortcut Keyboard shortcut not working Ulodesk Word VBA 1 02-05-2013 08:18 PM
Current time keyboard shortcut Keyboard shortcut for bookmarks Jennifer Murphy Word VBA 1 01-06-2013 07:38 PM
Keyboard shortcut for 'not highlight' in 'Find'? bertietheblue Word 0 05-02-2012 06:16 AM
Current time keyboard shortcut Keyboard shortcut for Set Numbering Value dlowrey Word 1 02-04-2012 05:00 PM
Outlook Keyboard shortcut sostrow28 Outlook 1 12-10-2010 05:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft