Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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 workbook, you will see the time change, and even as work within the workbook, say on this worksheet here if we start putting in some data or make some changes, we might check back here and this will have changed. Now just to test, as I might just press 1 and Enter, and maybe it hasn't gone beyond a minute. I don't know. But it has so we see it changed. Now at other times you didn't need to put in a date series and the standard way to do this is as with dates, just put in two separate times, and suppose you are tracking them workflow or something or maybe it's a bus schedule or something like that, maybe the buses leave every 16 minutes or something, so we might do something like this.
Put in two consecutive time entries, highlight them both, drag from the corner, you will get the series started that way. Whatever that first interval is simply gets repeated. If you had a situation like this where you wanted to experiment or maybe it's a different kind of situation where you want the times possibly to be different, you might put a time in a separate cell. For example, 0: I'll just put in 0:21 as an example, and you could change that number, but what if instead of having a serious here, we actually have a formula that's equals, whatever this amount is, plus this amount and then press F4 to make an absolute address.
If we then drag this down the column, that's our 21 min interval, but at another time maybe we want a 17 minute interval. It looks funny when we double-click because we see the AM, PM, but changes to be a 17, and now we have a 17 minute interval. So a couple of different ways to create time series here, and again that shortcut for putting in the current time and having it be dynamic is =now, the function Now, and you will do the formatting as needed.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 70527 Viewers
80 Video lessons · 127641 Viewers
52 Video lessons · 62535 Viewers
59 Video lessons · 48239 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.