LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default Date/time code, both, accesible by hotkey?

I've been using the ^+; a lot in my spreadsheets and by using a custom
format in the date cells. This has worked very well. But is there a way to
have both the current date _and_ time keyed in with _one_ hotkey rather than
using the ^+; for the date and then in another cell, CTRL+SHIFT+: for the
time? It would be nice to save the user time/aggravation by just using one
cell and one hotkey.

Thank you!


 
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
Converting text format of time/date into Excel time/date for subtr YY san.[_2_] Excel Worksheet Functions 6 February 25th 10 08:27 AM
Static Date and Time code problem Laura Excel Discussion (Misc queries) 12 August 31st 07 07:04 AM
MS Office Excel Date-Time Code Daniell Excel Discussion (Misc queries) 4 May 15th 07 05:48 PM
DATEDIF Function Should Be More Accesible Sloth Excel Discussion (Misc queries) 0 December 20th 05 11:19 PM
Calculating days & time left from start date/time to end date/time marie Excel Worksheet Functions 7 December 7th 05 02:36 PM


All times are GMT +1. The time now is 06:16 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"