Filtering Time ranges
I have data that includes 2 columns for a Start Time and a Finish Time of a
task. I want to be able to find all data that falls between a set time: e.g. want to find data that falls between 18:00 and 20:00. this may include data that has a Start Time of 17:45 and a Finish time of 20:30. Can anybody help with this please. MP |
Filtering Time ranges
MP,
Assuming that your first times are in A3 and B3 - in A2 enter 18:00 and in B2 enter 20:00. Then use this formula =OR(AND($A$2<=B3,$B$2=B3),AND($A$2<=A3,$B$2=A3), AND($A$2<=A3,$B$2=B3),AND($A$2=A3,$B$2<=B3)) and copy down to match your data. The formula will return TRUE if there is any overlap at all. You may want to change the <= and = to just < and .... HTH, Bernie MS Excel MVP "MP" wrote in message ... I have data that includes 2 columns for a Start Time and a Finish Time of a task. I want to be able to find all data that falls between a set time: e.g. want to find data that falls between 18:00 and 20:00. this may include data that has a Start Time of 17:45 and a Finish time of 20:30. Can anybody help with this please. MP |
All times are GMT +1. The time now is 12:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com