From the course: Excel 2016: Data Validation in Depth

Unlock the full course today

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

Time limitations with basic controls

Time limitations with basic controls

From the course: Excel 2016: Data Validation in Depth

Start my 1-month free trial

Time limitations with basic controls

“

- In the chapter four file, we're looking at a worksheet called time. The order dates are not there yet. They'll come in later. We're gonna restrict the entries though in column C. We only make sales between 8am and 6pm. So let's put a restriction in column C so that all the entries here, fall within that time frame. Data validation on the data tab, allow time, between is already prompted, in other cases of course, might be greater than or less than. This case, we're looking at both kinds of entries. The starting time, one way to type this can be eight colon zero zero, that's one way. End time, we could type 18 colon zero zero. We could type six colon zero zero pm. I think it's more consistent here to just use the 24 hour style so I'll put in 18 colon zero zero and click OK. Now, I'll type an entry here, maybe it's 8:45. Totally acceptable. It's 3:30 in the afternoon for the next one. Now if I type 3 colon thirty, I might be thinking 3:30 pm, but excel reads this as 3:30 am. And so as…

Contents