Forum Discussion
Filter between date and time
Hi Rob Nunley
There many ways to handle this I'll share you my best technique to handle such scenario
Since I have date & Time in my data I will add helper column to handle it effectively.
Helper Column with logical test of TRUE/FALSE
Create helper column check the date/time which each row using the below formula and just filter the values those are TRUE
Conditional Formatting
1. Create a custom rule with formula
2. filter the highlighted cell
=AND(A2>=$E$2,A2<=$E$3)Advance Filters
Use the same formula in cell and follow the steps as below
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
Hi Rob Nunley
There many ways to handle this I'll share you my best technique to handle such scenario
Since I have date & Time in my data I will add helper column to handle it effectively.
Helper Column with logical test of TRUE/FALSE
Create helper column check the date/time which each row using the below formula and just filter the values those are TRUE
Conditional Formatting
1. Create a custom rule with formula
2. filter the highlighted cell
=AND(A2>=$E$2,A2<=$E$3)
Advance Filters
Use the same formula in cell and follow the steps as below
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert