From the course: Excel: Data Validation in Depth

Unlock the full course today

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

Validating times with data validation

Validating times with data validation - Microsoft Excel Tutorial

From the course: Excel: Data Validation in Depth

Start my 1-month free trial Buy for my team

Validating times with data validation

“

- [Instructor] Explore California's summer internship program is off to a great and valid data start. As much as they want to fully integrate this data into their HR and payroll systems, they want to make sure the program is a success before they do that. That's because it's brand new. They have to track time and effort, and they want to make this as easy as possible for the new intern. So let's start by setting time validation. Okay, we'll go ahead and highlight C12 through C26. If we look at the notes up at the top, we can see that they can clock in any time between 8:00 and 9:00 AM. So let's set the validation so that it will only accept times between 8:00 and 9:00. I'll go to Data, I'll choose Data Validation. From the Allow dropdown, I'll choose Time. Again, I have the same options as I would for whole numbers, decimals, or even dates. Okay, I want to use Between. I'll click in Start Time. I'll type 8…

Contents