I need help in getting a count if the difference between a start and end datetime range is less than 15 minutes.
Column A1:A100 contains the start datetime, e.g. 1/23/2017 12:26
Column B1:B100 contains the end datetime, e.g. 1/23/2017 13:26
Idea is countif B1:B100-A1:100 < 15 mins.
Sample data attached
Bookmarks