LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Reverse_Solidus
 
Posts: n/a
Default Date/Time stamp with one stroke?

I know that you can have Excel insert the current date with CTRL + ; and the
current time with CTRL + SHIFT + :. Is there some way to insert both with
one command?

I know it seems like a small thing, but we have a worksheet for employees to
keep track of completed tasks. When they complete a given task, they need to
put the date and time of completion in a specific cell. However, over the
course of a day, they may be completing upwards of 250 tasks. Even lessening
the time to complete the time stamp by a single set of keystrokes would be
helpful.
 
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
Can excel have a button to input (stamp) the systems date and/or . abe Excel Worksheet Functions 5 April 24th 07 10:00 PM
Date/Time Macro Michael Link Excel Discussion (Misc queries) 6 February 15th 05 12:55 AM
How do i convert a number of seconds to a date/time? Margo Excel Worksheet Functions 2 January 5th 05 12:09 AM
Calculating date/time Paul Martin Excel Discussion (Misc queries) 1 December 7th 04 12:17 AM
Time Stamp without change AntonyY Excel Discussion (Misc queries) 3 November 26th 04 09:13 AM


All times are GMT +1. The time now is 04:29 PM.

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"