From the course: Google Sheets: Advanced Formulas and Functions

Unlock the full course today

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

Find the parts of a time

Find the parts of a time - Google Sheets Tutorial

From the course: Google Sheets: Advanced Formulas and Functions

Start my 1-month free trial

Find the parts of a time

“

- Many business systems record the time and date of an event, Such as a website visit or a page accessed. If you need to pull out the time element from a record, such as an event that occurred at 11:35 and 49 seconds, you can do so using the hour, minute, and second functions. In column A, I have a series of access times, I'm assuming these are page views on a website, and I'd like to pull out the hour, minute, and second of those times. Fortunately, the function names are exactly the bits that we want to pull out, hour, minute, and second. So let me show you how to do that. I'll first click in cell B2, and I want to find the hour from cell A2, the time in cell A2, so I'll type equal, hour, left parenthesis, A2, right parenthesis, press tab, and there is the hour. Hour one, which corresponds to what I see visually in A2. Now, I'll do the same thing for the minute. I'll type equal, minute, left parenthesis, A2, right parenthesis, and tab, and I get the minute of 13, for the second, it…

Contents