Using instant date/time entry


show more Using instant date/time entry provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010: Working with Dates and Times show less
please wait ...

Using instant date/time entry

For some users they enter the current date throughout the course of a day frequently, and some users even the current time. You could enter this information very quickly with a couple of great keystroke shortcuts. Suppose we want to put the current date in cell B2. As I am recording this in mid-July of 2010, Ctrl+; that's the current date. That's it. This is also handy if you want to put in, say in a different cell, a nearby date. Maybe you want to put in the 21st or the 28th or something like that. Ctrl+; and since I am still editing here change the 0 to 8 and do that, makes it fast.

Current time, the keystroke shortcut Ctrl+Shift+;. This will be the standard display. You can certainly change that. Depending on whether you might have had a date in here previously you might see this kind of a display, and so a simple right-click and Format Cells and a time entry, something like this perhaps, either this variation or the one that shows AM/PM. In both cases here, what you are doing ...

Using instant date/time entry
Video duration: 1m 27s 1h 20m Intermediate

Viewers:

Using instant date/time entry provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010: Working with Dates and Times

Subject:
Business
Software:
Excel
Author:
please wait ...