Auto-Fill techniques for entering times


show more Auto-Fill techniques for entering times provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Auto-Fill techniques for entering times

Here are couple of quick tips we are dealing with Times in Excel. One of the top 10 keystroke shortcuts was putting in the current time. Ctrl+Shift+Semicolon. That's handy. That's fast. It's not a dynamic time. It's, for example, the of this recording in the morning, sometimes you need to put in the time in such a way that it's going to be changing, and you want to perhaps use it as a time stamp or even use it within formulas. If you type the function Now =now (, Enter, you will see, if the column is right enough, I am adjusting it, the current date and the time and if you want to have just the time appear here you could right-click and quickly jump in to Format Cells. You can also get there by pressing Ctrl+1. Pick the time style that's most useful to you, the time format that is, either the 24 hour style, that will be 13:30, or the AM/PM style as you choose, either way.

But an entry like this will change. It is a function. As you open and close the current wor...

Auto-Fill techniques for entering times
Video duration: 2m 37s 3h 43m Intermediate

Viewers:

Auto-Fill techniques for entering times provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

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