From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Enter times and time series efficiently

Enter times and time series efficiently

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Enter times and time series efficiently

- [Voiceover] Not only can you work efficiently with dates in Excel, you can also work with times of day. Excel has all the mathematical capability to calculate differences between dates, setting up date series. When you enter dates, you should type a colon nearly all the time, there are some exceptions. If I wanna record the time 3:44, I'm gonna type three colon 44. But depending upon the context and how you're doing this, you might want to put in am or pm. Now, if I simply press Enter, I have entered the time, 3:44am. Now, depending upon the other dates that I might be using, that might or might not be a problem. If I wanna be sure that this is PM, one way to do this is Space + P. Don't have to type the M, Enter. It's likely to display this way. Another approach to this is to use 24-hour time. So that's 15 colon 44. Probably don't wanna use both of these in the same column, but you can certainly do it that way as well too. Now, if the times you're entering are on the hour, you need…

Contents