RE: filtering or selecting data baseed on time of day

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Insert a column near to the date and time column. Use the below formula to
get the hour minute format...If you need just the hour use "hh"...

=TEXT(I21,"hh:mm")
--
If this post helps click Yes
---------------
Jacob Skaria


"TBA" wrote:

Hi there. I have rows of date, one field is a start time that has full date
and time of day a phone call was initiated. I want to filter only those calls
made between specific times, but across all days (a monthds worth of calls).
when I try time based filters it looks at the complete record, i.e. time
between one day/time and another day/time. I want to have all days but
between times on all those days...any suggestions? thanks!
.

Relevant Pages

  • Re: bash, grep, and regular expressions
    ... but not something that will filter exclusively on ... >>This will filter to return directories only with the first grep command ... selective statement. ... It's as if grep doesn't recognize the space between the time column and ...
    (Debian-User)
  • Re: Filter by Time
    ... did you try applying an autofilter to the range and using the dropdowns to filter the records on the time column? ... Gary Keramidas ... Excel 2003 ...
    (microsoft.public.excel.misc)