RE: needing a keystroke for the current date AND time

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Gary''s Student <GarysStudent@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 6 Nov 2008 12:07:01 -0800

If you assign a shortcut key like CNTRL-e to this macro:

Sub DayTime()
ActiveCell = Now
End Sub

It may do the trick
--
Gary''s Student - gsnu200812

"Scotta0471" wrote:

I know that CTRL + ; gives the current date, and I know that CTRL + SHIFT + :
gives the current time. Is there a keystroke that gives the current date AND
time? I'd like to enter a start time quickly in one column and then a
closing time in another and have it calculated in a third. The individuals
who will be filling out this spreadsheet need a very quick and dirty way to
do it. Thanks.

References:
- needing a keystroke for the current date AND time
  - From: Scotta0471

Prev by Date: RE: Get Part of Cell
Next by Date: RE: Need formula to increment cell reference every 8th row
Previous by thread: needing a keystroke for the current date AND time
Next by thread: RE: needing a keystroke for the current date AND time
Index(es):
- Date
- Thread

Relevant Pages

Re: Replace Line Feed
... Gary''s Student wrote: ... You can use this trick to replace a variety of non-type-able characters. ... If you format a cell to wrap text, you can artificially put in a Line ... I have a spread sheet with a lot of Line Feeds, ...
(microsoft.public.excel.misc)
Re: Why I stop attacking HLA
... > Betov wrote: ... >> Propaganda trick he is much used to. ... > by and large the average student does far better when their education ... > produce a much better educational experience for that student. ...
(alt.lang.asm)
Re: Tricky examiners
... But if the student didn't react well to the trick, ... Looking through the PTS, I don't see anything on the examiner's test ... checkride over an issue that is not required by the PTS. ...
(rec.aviation.piloting)
Re: [CRIT] Opening
... it wasn't a trick or a test. ... having with that pattern?" ... less of him as a person and as a teacher because of it. ... and I don't think that discussing one student behind ...
(rec.arts.sf.composition)
RE: Macro to copy and paste row
... This first inserts the new blank row below the ActiveCell and yjrm does the ... Sub Macro1() ... Gary''s Student - gsnu2007k ... active cell is in and paste the content into a newly inserted row ...
(microsoft.public.excel.programming)