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.
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:
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 Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
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!