From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Time, rounding, and converting to decimals

Time, rounding, and converting to decimals

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Time, rounding, and converting to decimals

“

- [Instructor] Now let's look at some advanced ways of working with time. Now, time can be a deep, deep rabbit hole in Excel and a lot of it involves formatting. And in fact, I have a formatting course that you can check out that does go deeper into times as do a lot of other courses on the LinkedIn Learning Library. So, we're going to do a few things in this video. In column B, I have a list of arrival times that I want to round to the nearest 15 minutes. Now I'm going to go into cell C3. So to get this rounded to the nearest 15 minutes we're going to M round equals M round. Double click. What is the number we want to round? It is right here. Coma, the multiple N double quotes, zero, colon, 15 double quote. Close parenthesis. Enter. 10:17 has been rounded to 10:15. Yep, that is the nearest 15-minute mark. Go to the field handle, double click, send it down, and then let's look at this one. The arrival was 10:00…

Contents