From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Round times to the nearest 20 minutes

Round times to the nearest 20 minutes - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Round times to the nearest 20 minutes

“

- [Instructor] Here we go, let's work with times. The goal is in the official time column, we need to calculate to the nearest 20 minutes, what time the person clocked in. But, if that time winds up being earlier than the scheduled start time, then bring over the scheduled start time. Look at Molly. Molly is not scheduled to start until 8:00 AM, but for whatever reasons, she clocked in at 6:22 AM. So 8:00 AM needs to be in Molly's official time, okay? Round the numbers to the nearest 20th minute, and pay attention to the schedule start times. Right, pause the video, it's that time, calculate the times, and then come on back. (upbeat music) Okay, let's get these official times. I'm going to start this way, equals mround, open parenthesis, what number do we want to round? The clocked in time, comma, what multiple do we want to use? Here's what we got to do. Time, going to use that function, and then the hour, zero…

Contents