Forum Discussion
Filter between date and time
I have an Excel spreadsheet with a large number of entries. There is a Date/Time column in the following format: mm/dd/yyyy hh:mm. I have need to filter the data between yesterday at 14:00 and today at 13:59. I've search high and low but have not been able to find a solution.
Thanks!
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
Rob Nunley As a variant, and if you are using the latest Excel that recognises the FILTER function, perhaps you'll find the attached solution helpful.
