## How to check if time is between two times in Excel?

In Excel, how could you check if a specific time is between two given times? To check them one by one will waste lots of time, here, I will introduce some simple formulas to solve this job.

**Check if a specific time is between two given times with formulas**

#### ** Check if a specific time is between two given times with formulas**

For example, I have two columns of times which are start time and end time in column A and column B separately, now I want to check if the time in column C is between the time range in column A and column B as below screenshot shown:

The following formulas may help you to identify if the specific time is between two times, please do as this:

Enter any one of the following formulas into a blank cell beside your data where you want to output the result:

**=IF(C2=MEDIAN(A2,B2,C2),"Yes","No")**

**=IF(AND(C2>=MIN(A2:B2),C2<=MAX(A2:B2)),"YES","NO")**

And then drag the fill handle down to the cells which you want to apply this formula, and the time if between the given two times has been identified, if it is between two times, a Yes will be displayed, if is not between the two times, a No will be displayed, see screenshot:

**Note:** In the above formulas, **C2** is the specific time you want to check, and** A2** and **B2** are the cells contain the two times that you want to check based on.

### Best Office Productivity Tools

**Supercharge Your Spreadsheets： Experience Efficiency Like Never Before with Kutools for Excel**

**Kutools for Excel boasts over 300 features, ensuring that what you need is just a click away...**

Supports Office/Excel 2007-2021 & newer, including 365 | Available in 44 languages | Enjoy a full-featured 30-day free trial.

#### Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!